Business Dimensions

Business dimensions describe the business-specific objects within each stage in the model, such as products, customers, regions, and employees.

Business dimensions may use some or all of the following dimension types, and may apply to one or more stages or models:

• Generic

• Account

• Entity

• Country

When the Oracle Essbase outlines are deployed, the business dimensions are created in the Oracle Hyperion Profitability and Cost Management application as basic or generic dimensions, with no type. This feature enables Profitability and Cost Management to reuse the dimension member and hierarchies that were defined for other applications, such as Oracle Hyperion Planning.

Note:

This dimension type does not apply to aggregate storage outlines.

When creating a business dimension, the following requirements apply:

• The following properties for the Gen1 member of the dimension must be set to LABEL_ONLY:

  • DataStorage(BSO)

  • DataStorage(ASO)

• The first Gen2 child under the Gen1 dimension name is usually set to an All member. For example, AllDepartments for the Departments dimension.

  The primary hierarchy is hosted under the first Gen2 child. Only the first Gen2 hierarchy is used in allocation modeling, and this hierarchy cannot contain shared members.

• Additional Gen2 members can host alternate hierarchies, but these hierarchies are not used in allocation modeling. If the dimension is going to host alternate hierarchies, set the Dimension HierarchyType to "Enabled", the first Gen2 member HierarchyType to "Stored" and the Gen2 member with alternative hierarchy with shared members to "Dynamic"

  These alternate hierarchies are not visible in Profitability and Cost Management modeling screens, and can only be viewed in Essbase.

• A NoMember member is required. The last Gen2 child in the hierarchy must always be NoMember with consolidation set to IGNORE (~).