Models are used to capture or report on data in an application. Models define the OLAP cubes generated by Kepion. Using the Dimensions provided in the Integrated Financial Planning Sample Application, we will discuss how to use Models. For more information on Models, review the Modeler Tutorial - Part 3.
Tip: Download the Integrated Financial Planning Sample Application.
Create a Model
Hover over MODELER and then select the app of your choice (Integrated Financial Planning).
Select the All Models node.
To create a Model, click the Add button.
Name the Model in the Model Name box. Click Save once everything looks correct.
Note: Copy From allows users to create Models based off of previous Models. This can help users save time when they already have a Model that has a similar selection of Dimensions. While the structure of the Model is copied, the data is not.
Navigate to the Model that you just created under the All Models node. Select the checkboxes of the Dimensions you want to remove. Click Remove . Press OK when the pop-up window appears.
Click the Add button.
Add the Dimensions that you need by clicking the checkbox next to the Dimension's name. Click OK.
Click the Save button the save the application. Click the Deploy button once you are ready to deploy your application. Deployment will drop and then build all of the OLAP Cubes defined by the Models.
Delete a Model
Go to the All Models node. Select the Model's checkbox. Select the Remove button.
Group a Model
Click on the Model of your choice. Select the Edit icon.
Type the name of the Group. Click the Save Icon to save all changes.
In the previous sections, we were working in the Model Dimension tab. However, there are two additional tabs: Linked Model and Perspective.
- Linked Model: Links multiple Models together so Models can share Measures and Dimensions. This helps create Model Validations.
- Perspective: Assists with the creation of a more user friendly interface for third-party analysis tools when connecting to a Model’s data.