16 Working with Properties

Dimensions include properties that are used by their nodes. The Properties page lists the properties that can be added to dimensions. Oracle Enterprise Data Management Cloud provides an initial set of properties. You can create custom properties from the properties page or when you register Universal applications.

The properties available to an application's dimensions depend upon the application type:

  • When you register a Universal application, you can create custom properties or select existing properties.
  • When you register an Oracle Fusion Cloud Enterprise Performance Management application, properties are automatically added, based on the dimensions' Dimension Types.

You can customize how properties are displayed in viewpoints. For example, you can display an alternate name for a property, see Understanding How to Configure Properties for a Viewpoint.

An application's type determines some characteristics of properties, as described in the following table:

Table 16-1 Properties and Application Types

Application Type Property Considerations
Oracle Cloud EPM applications You cannot add or remove properties. The only properties available to nodes are the properties automatically added when the application was registered. For application-specific properties, see:
Universal applications
  • You can add properties for non-Universal application types. For example, you can add a Planning property to a Universal application.
  • You can add or remove properties from a dimension's node type.
  • You can delete custom properties as long as they are not referenced by any other data chain object or by an application registration.

Note:

  • Oracle Cloud EPM applications may have unique considerations. If so, those considerations are described in the topic for the application type.
  • For all application types, you can add properties that are not registered with the application to a node type, thus making the property available in viewpoints. Unregistered properties added to node types are not included when you import or export an application's data.

    Why would you add a property to a node type if it cannot be imported or exported? You can use such properties to customize sorting or to include descriptions and comments for Oracle Enterprise Data Management Cloud users.

Property Data Types

Properties are defined using the following data types:

  • Boolean
  • Date
  • Float
  • Integer
  • List
  • Memo
  • Node
  • String
  • Timestamp

Property Level

The property level determines where property values are defined:

  • Node: Defined property values apply to that node across all locations and viewpoints.
  • Relationship: Defined property values are unique to specific parent-child relationships within a hierarchy set.

Caution:

Property level applies to defined property values only. Inherited and derived values (if the default expression uses positional logic) may not conform to the node and relationship level constraints. See Inheriting Properties and Derived Properties.

Property Origin

The property origin identifies how a value originated for a node. Property values can have these origins:

  • Default: value can be configured when an application is registered

  • Defined: value is defined by the user

  • Inherited : value is inherited from an ancestor node

  • Derived: value is calculated. For example, number of children

  • Unknown: the origin of the value cannot be determined

For more information, see: