Author: Ian Britz
Introduction
The next thing we'll need to do is use our Dimensions to create Models. Models are used to capture or report on data in an application. In order to capture the data, we need to use the related Dimensions as part of the Model definition.
Models
Step 1. Navigate to the All Models node in the right-hand navigation pane. Select Add to create a new Model.
Step 2. We'll call the first one Assumption, as it'll be used to enter our base assumptions about the product we're selling; for example, the number of units we plan to sell and the price we plan to sell them at.
Step 3. The default Model includes both the Account and Time Dimensions. We won't be using the Account Dimension in our Assumption Model, so select it and click Remove.
Step 4. Then click the Add button and include the Metric, Product, and Scenario Dimensions.
Note: As a best practice, you should always add Dimensions through this process. The Add Role Dimension feature below is a more advanced technique with a limited use case.
If a Dimension that we add has multiple Member Lists, we can select which one we want to use here. For the Time Dimension, ensure the Months Member List selected.
Step 5. Next, return to the All Models node and create another Model. We'll call this one Expense. It will be used to track all of our operational expenses. All we need to add here is the Scenario Dimension.
Step 6. Lastly, let's create our Reporting Model.
As the Expense and Reporting Models both use the same three Dimensions, let's use the Copy From field to create a copy of the Expense Model.
Step 8. Kepion uses both a SQL Database and SSAS Database. The SQL Database holds all the tables and data in the application, while the SSAS Database contains aggregations of table data. In order to build the OLAP Cubes defined by the Models in the SSAS Database, we need to deploy the application.
Note: Any changes we make to the Dimensions or Models will require that we re-deploy the Application.
Next Steps
Now that we have our Dimensions combined into Models, we can start creating the first two Forms we need in our Assumption Model.
Comments
0 comments
Please sign in to leave a comment.