In this chapter, we have discussed the basics of Cognos TM1 virtual and lookup cubes focusing on what you will need to know and be comfortable with before taking the current IBM Cognos TM1 Developer (Test COG-310) certification exam. We have also looked at some practical examples.
In Chapter 8, Time Considerations, we will discuss the importance and use of the time dimension in Cognos TM1.
There are some important points about virtual and lookup cubes:
There are four types of cubes in Cognos TM1. They are as follows:
Standard cubes
Control cubes
Virtual cubes
Lookup cubes
A standard Cognos TM1 cube is referred to as a hard cube or a cube where data is actually loaded and resides.
TM1 control cubes by definition, are hard cubes that hold data.
All control cubes are named with a first character of
}
and are by default not-visible within TM1 Server Explorer.A virtual cube is a TM1 cube which is referred to as a soft cube where no data actually is loaded to or resides in, but references...