October 2011
Intermediate to advanced
512 pages
10h 42m
English
So now that you understand the subcubes are important, let’s define what makes up a subcube so you can better design them. The account, ICP, and customs for a period make up the subcube. Data for a different currency, year, or scenario exists in separate subcubes.
Each subcube is defined by the Page dimensions and contains all the members of the Subcube dimensions. The Page dimensions are Scenario, Year, Entity, Value and View. The Subcube dimensions are Account, ICP, Period, Custom1-4. The subcube consists of the stored data records for these combinations of dimensional intersections. That is, it is the actual number of populated records that make up the size of your cubes. You can estimate the size ...
Read now
Unlock full access