Modifying Properties

From the Dimension Library, you can edit these properties:

  • Applications

  • Dimensions

  • Members

Properties are organized into categories:

  • System—used to identify characteristics of a member, such as name, description, and if the member is inactive.

  • Statistical—used to provide statistical information about a member such as number of children and number of siblings.

  • Essbase (ASO)—Essbase Aggregate Storage Option (ASO) applications

  • Planning—used for Planning applications

  • Essbase (BSO)—Essbase Block Storage Option (BSO) applications

  • Consolidation—Financial Management applications

  • Profitability—Profitability and Cost Management applications

Dimension property categories are defined in product-specific chapters:

Each chapter describes these properties, their possible and default values, as well as other characteristics that determine how they should be used. Properties can be global or relationship:

  • Global Property—The value of global properties is static for all instances of the member in the hierarchy, including shared instances and orphan instances. For example, the Currency value for Entity member “Kansas” is “USD” for both instances of the member “Kansas”, under “United States” and also under “Management”. The value of global properties can be changed at any instance of the member and the change will be reflected for all instances of the member.

  • Relationship Property—The value of relationship properties applies to a particular instance of a member in the hierarchy. For example, the value of “Aggregation for Plan 1” for the Entity member “Washington” can be set to “+” when the member is under the parent “United States”, but can be set to “Never” when “Washington” is under “Management”.

Properties for members of dimensions can also be inherited. There are two types of inheritance: relationship inheritance or application inheritance.

  • Relationship Inheritance—The default value is obtained from the value of the property for the parent of the member in the dimension. An inherited property can be global or vary by relationship. A global inherited property inherits from the parent of the primary member in the dimension. A relationship inherited property inherits from the parent for each instance of a member since the property value can differ by relationship. An inherited value is only a default value and can be overridden by a stored value for a member. In this situation, a change to the parent for this property would no longer affect the member because the inheritance was overridden.

  • Application Inheritance—The default value of a property for a member in a shared dimension in an application is inherited from value of that member in the Shared Library. At the application level, you can override the Shared Library inherited property value with a value local to the application. The inherited values are only default values for the members in the application, so they can also be overridden within the application. Any changes to the dimension in the Shared Library would no longer affect the property for the member once overridden.