Support Center

Workflow Dimension Permission

Configure workflow dimension security.

File Store Attachment

File store allows you to upload attachments through a Kepion dashboard and share files of any type with your teammates. You can create file stores and manage the associated files by dimension. Before You Start Here are some things to know before you begin this process. File size limit: … Read More

Workflow Rule

A Workflow Rule allows you to run SQL statements upon workflow actions, such as Post, Approve, Reject, etc. Use Case In this example, we have an advanced workflow configured for Revenue Planning. We would like to archive Forecast data when an Approver clicks “Approve” on the Dashboard Action Menu. … Read More

Backup Application DB

You can transfer an application between environments with the backup and restore process of SQL Server.  This guide will cover the backup aspect of SQL Server. Open Microsoft SQL Server Management Studio and connect to your instance of SQL Server. Expand the Databases node, and locate the application database.  … Read More

Update MemberVariable Programmatically

MemberVariable can be used as default value of filter.  To modify the selected value of MemberVariable programmatically, we need to update both UniqueName and Properties column in [dbo].[ApplicationMemberVariableMembers] table. Assume we have a member variable called Current Month.  Here is a sample query that we can use to update … Read More