Creating a Cube

A cube stores the data in a Multi-Dimensional fashion which helps the business to analyze the data from multiple perspectives.

1) TM1 cube stores data for reports, analysis, and staging data for further calculations.

2) Data can be come from multiple sources and be arranged in a multi-dimensional format called Cube.

3) Each cube contains data, business logic, measure rules , and calculations.

4) TM1 cube should have alteast one measure dimension and one or more regular dimensions.


Creating a Cube

1) Right click on Cubes and click on Create new cube.
2) Creating Cube window opens. Enter the name of the Cube and select the required dimensions from Available Dimensions list.
3) Click > (right arrow) to bring them all into the Cube and set the order for the dimensions by clicking up and down arrows.
4) Click on Create Cube and the Cube will be placed under Cubes.
5) Expand the Cube and see the dimensions that you have selected.
6) Dimensions can be re-order even after creating the Cube. To re-order, right click on the Cube and select Re-Order Dimensions.
7) Double click to open the Cube. All dimensions under the cube will be available to browse through the data.
8) Select a Dimension and pull down to left most to view the data based on that Dimension.
9) The data can be viewed across all dimensions.
10) For any dimension, if you want to see the aggregated data, click on RollUp button. It'll sum up all the values and give us the Total value.
11) In any Dimension, if you want to filter the elements click on Filter by widlcard icon and give the value. It exactly works as a search string.
12) After selecing the dimensions view, click on Recalculate to view the data. By default Cube shows all the data values inlcuding 0s.
13) We can ignore the 0s and pull only non-zero values by clicking x0 icon on the Icon Tool bar.
14) Automatic recalculate icon is used to refresh the data automatically. We won't need to click Recalculate when we change the dimension view.
15) We can download the data into an Excel sheet by clicking on Snapshot icon.
14) After selecting the dimension view, we can save the TM1 view by clicking File->Save.
15) TM1 Save View window opens. We can either choose Private or Default to save the view.
16) Check Private if you want the view to be available for only current user. Uncheck it if you want it to be made Public. Default option will make it default view and it opens that when the Cube is opened.
17) The cube can be loaded with TI Processor.