Financial Management Records and Subcubes

A record in Oracle Hyperion Financial Management holds the data for all base periods for a given intersection of dimension members.

A subcube consists of all the cells that share the same members of the following dimensions:

• Scenario
• Year
• Entity
• Value

There are two types of subcubes: currency subcubes and node subcubes. These types of subcubes differ in how they use Entity and Value dimension members:

• A currency subcube contains cells that share applicable non-node Value dimension members. For currency subcubes, the parent of the Entity member is irrelevant. The applicable non-node Value dimension members are as follows:
  • Members for user-defined currencies. There is one triplet of Value dimension members for each user-defined currency. For example, if an application contains a currency named USD, the currency's triplet of Value dimension members will be USD, USD Adjs, and USD Total. The triplet is still considered as three separate subcubes.
  • The triplet that points to the entity's default currency. This triplet consists of the <Entity Currency>, <Entity Curr Adjs>, and <Entity Curr Total> Value members.
  • [None] Value member.

  Note:

  The non-node Value dimension members that point to parent entities' default currencies - <Parent Currency>, <Parent Curr Adjs>, and <Parent Curr Total> - are irrelevant to currency subcubes.
• A node subcube contains cells that share a common node Value dimension member. For node subcubes, both parent and child Entity members must be specified. The node Value dimension members are as follows:
  • [Contribution Total]
  • [Contribution Adjs]
  • [Contribution]
  • [Elimination]
  • [Proportion]
  • [Parent Total]
  • [Parent Adjs]
  • [Parent]

Because the subcube is a natural unit of data for the purposes of consolidation, data movement and processing are carried out on a subcube basis in many places in Financial Management.