Getting Started

Server Memory Allocation

We highly recommend configuring the memory threshold of SQL and SSAS server. Otherwise, each server will consume as much available memory as possible, therefore it will kill the environment. We have two best practice suggestions for memory allocation: Always ensure the OS for the machine has at least 2G … Read More

What Excel Functions are Supported in Kepion Forms?

The following functions are supported in Kepion forms. Function Example SUM =SUM(A1:A2) AVERAGE =AVERAGE(1, 2, 3) AND =AND(A1, A2) OR =OR(A1, A2) NOT =NOT(A1) IF =IF(A1, TRUE, FALSE) ISNA =ISNA(A1) ISERR =ISERR(A1) ISERROR =ISERROR(A1) ISNUMBER =ISNUMBER(A1) VLOOKUP See Excel online documentation HLOOKUP See Excel online documentation

Creating a Kepion app in the Azure Marketplace

1 Preparation Sign in to, and make sure you have an Azure subscription. 2 Purchase the Kepion Cloud app from the Azure Marketplace Open the URL below in your browser Click Create Virtual Machine. Click Create to continue. Basics Please use the exact value for the Name … Read More

Introduction to Modeler

This is a brief introduction to the Kepion Modeler that walks you through the process of creating an application within Kepion. For advanced modeling techniques, check out the Advanced Modeler series. Length: 09:00 Introduction to Modeler Dimensions & Hierarchies Models & Fact Data Business Rules Input Forms & Reports

Workflow & Security Setup

This video provides a how-to guide on setting up users, groups and roles and security permission to applications within Kepion. Also provides guidance on configuring workflows for your users. Length: 08:13 Introduction to Administrator User & Group Security Model & Dimension Permission Workflow Plan Process Tracking