After creating a number of Shared Dimensions, it is time to create our first cube.
When you create a cube, you must select a fact table. A fact table is a table that contains measures. In our solution, this is the Sales Invoice Line table. Furthermore, a cube can only contain one fact table.
Next step is to select one or more measures from the fact table. Right click the Measures folder to add measures.
You will get a full list of all columns in the fact table. In short, measures are the numerical data that makes sense to summarize and average.
At first, we will select two measures:
- Amount
- Quantity
If necessary, we can change the properties of these measures. E.g., the Quantity measure can be formatted to show no decimals.
Now it is time to add the dimensions from our Shared dimensions repository to our new cube.
As we will see later on, the Shared dimensions repository can hold dimensions that are relevant only to some cubes, while other dimensions are relevant to other cubes. Select those relevant to your current cube.
Once you save the Data Model, the data – as defined by measures and dimensions in the new cube – will be available for analysis purposes in the TARGIT client. Of course, this is provided that you already set up a connection on the TARGIT server to the InMemory database – as we did in one of the previous lessons.
Comments
Is there documentation somewhere on the Aggregate type option of a measure? Specially the Custom one?
An how about the Partition by one?
Hi Sylvain,
I have done an article on the Custom aggregation type: https://community.targit.com/hc/en-us/articles/16808010197916-Custom-aggregation-type
Still working on the other one.
BR / Ole
Please sign in to leave a comment.