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

Consolidating data with a virtual cube

Another example of using a virtual cube is entity consolidation. For example, suppose a corporation consists of several legal entities that must report their financials to the parent. The parent as well as each legal entity (LE) has its own Profit and Loss (P&L) cube in TM1. The parent's financial reports must include all of the legal entities. To do this we could make the parent's P&L cube a virtual cube that includes rules that pull from each of the entities in the P&L cubes.

So, for example, in the parent P&L cube we have:

['8151', 'Legal Entity 1'] =N: DB('LegalEntity1 P&L','8151',!Legal_Entity,!Version,!_Source,!_Period,!_Currency);

The above rule will pull the value for the account 8151 for the entity ...

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