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 ...