Form & Reports Format

Drop-down Display by Attribute

You can change the way drop-downs are displayed in a form by using an alternate display attribute from the underlying dimension.  You can do so by editing the drop-down template.  Click on the settings “gear” icon to open up the editor dialog window. Drop-downs that are of type ‘Hierarchy List’ … Read More

Enhanced Cell Attributes

You can define advanced form formatting through the use of Cell Attributes.  In the example below, we have three Cell Attributes, each highlighting the cells to a certain color. Right click on a cell in the form, and choose “Define Cell Attributes“.  Select the FORMAT tab.  You can apply … Read More

Create Tiles in Dashboard

Tired of forms and charts? Let’s create a tile to summarize your key information on a dashboard. A tile is a form with special formatting. Step 1 – Create a form that shows the data you’d like to see. For example, I’m creating a form with Account on the … Read More

Formatting Guidelines

Kepion allows you to format a form in a different ways based on your needs. General form formatting Hierarchy-based formatting Scope formatting Two more options are available to define data format. Dimension member formatting Using MDX rules We’ll describe the first three in details below.  For the latter two, … Read More

Scope Format

In dynamic forms, row/column axis definition can be based on filter selection. In these cases, formatting by row, column, or cell will not work properly. For example, in the form below, accounts on the row axis will dynamically change based on the Employee filter selection. Row 11 has been … Read More