Creating Dynamic Dimension Templates

This chapter provides an overview of dynamic dimension templates and discusses how to create dynamic dimension templates.

Click to jump to parent topicUnderstanding Dynamic Dimension Templates

A dynamic dimension template is a set of default values to be used automatically for dynamic query and tree members. Because dynamic objects are not stored within the dimension, using a template enables the dimension builder to define what properties would be applied to the majority of members within the dynamic query and tree.

For members that are stored within the dimension—for example, having a dynamic query with all the consolidation properties in one location, and another dynamic query with all the consolidation properties in a different location—using templates enables you to set those values without setting them manually.

Using templates is optional. If you do not use templates, the system uses a default built-in template that assigns default values to each of the member’s attributes. The default values are displayed in the Dynamic Dimension Templates page. If these default values will always be used, then templates should not be used.

Click to jump to parent topicCreating Dynamic Dimension Templates

Access the Dynamic Dimension Templates page (CUB_TEMPLATES) by selecting PeopleTools, Cube Builder, Dynamic Dimension Templates.

Use the Dynamic Dimension Templates page to create Essbase dynamic dimension templates.

Object Owner ID

Select the owner of the template.

The owner ID helps to determine the product, feature, or application team that last made changes to this template.

Consolidation Property

Define the mathematical operator used for rolling up members. Most often, you expect that data is added (using the + operator) when rolled up. However, you might occasionally need to specify another operator.

See Defining an Essbase Dimension.

Expense Report

Essbase has built-in formulas that take advantage of the knowledge that an item is an expense. To pass this knowledge on to Essbase, select this check box .

Time Balance

Time balance affects how the parent time value is calculated. Select from these values:

  • 0: none

  • 1: first

  • 2: last

  • 3: average

Skip Option

If the Time Balance value is first, last, or average, then select a skip option that Essbase will use when it encounters missing values or 0 values.

Available options are:

  • Missing

  • Missing and Zero

  • None

  • Zeros