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 Legal Entity 1
into the parent cube. Of course, it might be wise to not specify the account 8151
so that all accounts that exist in both the parent and entity cube will be pulled in without having to have a rule for each of the...