Subcubes - How HFM Stores Data

HFM organizes data into sections called "subcubes" which is a set of records that allows HFM to cache portions of the database into memory.

A subcube is made up of:

• 1 member from Scenario, Year, Entity, and Value dimensions
• all members of Account, ICP, View, and any Custom dimensions
• Each Account, ICP, View, and Custom dimension combination contains 12 values which is for the 12 months of the Period dimension.

HFM then stores these subcubes in one of three tables:

• DCE (Currency Subcube) - Stores Entity and Parent Currency values and their adjustments.
• DCN (Parent Subcube - Stores remaining Value dimension members
• DCT (Journal Transactions) - Stores Journal transactions. When JEs are posted, they are transferred to either DCE (for and ) or DCN (for and )