O'Reilly logo

IBM Cognos TM1 Developer's Certification Guide by James D. Miller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Granularity—the lowest level of time detail required

Granularity is the extent to which a system is broken down into small parts, either the system itself or its description or observation. It is the extent to which a larger entity is subdivided—Wikipedia.

The most common granularities for a time dimension are:

  • Month
  • Week
  • Day

Month—two time dimensions

Cognos TM1 cubes that store data at the monthly level of detail may have one or two time dimensions. If you have two, this would mean that you will have one dimension for the year and one dimension for the month.

Why would you have both a year and a month dimension, in the same cube?

Some of the advantages of separating the year and month into two dimensions include:

  • It is easier for year on year comparisons. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required