Data Types and Exchange Rate Types

The Data Type determines how values are stored in account members, and the exchange rates used to calculate values. Available data types for account member values:

• Unspecified

• Currency - Stores and displays in the default currency.

• Non-currency - Stores and displays as a numeric value.

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

• 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.

In a multiple currency application, for members with the Currency data type, available Exchange Rate types (valid for any time period):

• No Rate– Closing Balance of translated data is adjusted to an Ending Rate translation by calculating Foreign Exchange variation on Opening Balance and Movements.

• Historical – Closing Balance accumulated as a weighted average of the translated movements with no net Foreign Exchange variation. Foreign Exchange variation is calculated but then transferred to Cumulative Translation Adjustment / Unrealized Gain or Loss on Translation.

• Historical Amount Override – Override amounts can be entered and the account is otherwise treated as a Historical account.

• Historical Rate Override – Override rates can be entered and the account is otherwise treated as a Historical account.

Note:

Ending Rate and Average Rate are both treated as No Rate whether the account is Flow or Balance.