The Subcube and Its Impact on Your Design

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

Get Oracle Hyperion Financial Management Tips And Techniques 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.