In this chapter, we will discuss the most basic Cognos TM1 objects:
Cubes
Dimensions
We will identify and explain each of these objects—focusing on the information covered in the current IBM Cognos TM1 Developer (Test COG-310) certification exam.
The current certification exam assigns a weightage of 16 percent to this topic.
What tables are to relational databases in the way cubes are to TM1. Almost all data stored in TM1 is stored in and accessed from cubes.
There are two ways to create cubes:
Empty cube: You can create an empty cube by selecting (at least) two dimensions from the list of existing dimensions in the Creating Cube window to create a new cube with no data.
External data sources: You can create a cube and load it with data by using TurboIntegrator to identify and map dimensions and data from an external data source to a new or existing cube (of course, this requires some expertise using TurboIntegrator).
Each...