You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Retrieve Entity currency in Essbase Rules

Received Response
edited Oct 8, 2020 5:18AM in Financial Consolidation and Close 5 comments


We need to obtain the entity currency of the current entity being processed to compare that against a list of currencies.


In HFM you could extract the currency or value layer of the current entity by using either
HS.Value.Currency() or HS.Entity.defCurrency("").

This value could then be compared against a set of currencies to then do specific actions on certain currencies, or this could then be combined with a prefix to sue a member in one of the custom dimensions if you had a list of currencies for disclosure purposes.

E.G HS.Exp "A#Disc Account.C1#IFRS7_Curr_" & HS.Entity.defCurrency("") = 500.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!