In this chapter, we have discussed the basics of the time dimension in Cognos TM1 focusing on what you 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 for defining time with a TM1 application.
There are some important points that you must know:
Cognos TM1 applications will most often be used to view, compare, and predict information over time.
Of all the considerations for deciding what dimensions should make up a TM1 cube, time is one of the (if not the most) important.
The vast majority of TM1 cubes will have at least one time dimension.
Granularity is the lowest level of time detail required.
The most common granularities for a time dimension are Month, Week, and Day.
Cognos TM1 cubes that store data at the monthly level of detail may have one or two time dimensions.
When using a two dimensional time model, a rule of thumb might be for financial cubes...