Forms are an integral part of any Kepion Application. They are used within Dashboard Apps and can be used to create visualizations within Kepion or Power BI. To ensure other parts of the Application are running smoothly, we recommend optimizing Form performance wherever possible. Below are some options that you can consider.
Set Default Filter Members
Always select the lowest Member within a hierarchy as the Default Member to optimize performance when a Form is first opened.
Use SQL Over MDX
When possible, use SQL scripts over MDX scripts. Using SQL scripts will help improve the performance of both your Form and your Application.
Add Cell Attributes
Add cell attributes whenever you need dynamic formatting that will affect the Dimension Members on a Form. Cell attributes are also used to validate input and override certain properties of a cell.
Use Static Cell Formatting
If you need formatting that isn't dynamic, we recommend you format by rows and or columns because it will decrease the overall Form size. For example, if you want to add a splash of color to your Form, you can highlight the row, and select your color of choice.
Hide Empty Rows and Columns
Turn on the Hide Empty Rows and Columns options. This shrinks the size of the Form to just where there is data.
To simplify your Form's design, considering doing the following:
- Limit the number of Dimensions on the rows or columns.
- Limit the scope and size of the Form.
- Shrink large Forms down with more Filters.
- Disable unnecessary features, or redesign the Form in a way that doesn't need them (annotations, drop-downs, cell attributes, increase/decrease colors).
Use Multiple Forms
Break large Forms into multiple smaller Forms, and place them side-by-side on a Dashboard.
Build Validation Relationships
Build Validation Models and define relationships between Dimension Members, to limit how many actually need to exist on the Form.