Data Type

Data type determines how values are stored for dimension members.

Available data types for dimension members’ values:

• Unspecified

• Percentage: Stores a numeric value and displays as a percent.

• Smart List

• Date: Displays as a date.

• Text: Displays as text.

• Transient Text: Displays as text without storing.

The Transient Text data type displays text in forms which doesn't need to be persisted. For example, real-time inventory data can be pulled from an external system (REST API), and then it can be displayed in the form using a post-load Groovy rule for that form.

Note:

Transient Text is not stored in Essbase or in the relational database. If an existing member is changed to use the Transient Text data type, then the existing data will not be displayed in the form and the data will not be deleted from Essbase.