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 ...
Get IBM Cognos TM1 Developer's Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
