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:
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.