HsCurrency

Data sources: Oracle Hyperion Financial Management, Oracle Hyperion Enterprise® (private connection only)

HsCurrency retrieves the currency value of the specified dimension member. Entity and Value are the only valid members for the HsCurrency function.

Syntax

Private connection:

HsCurrency("PrivateConnectionName,Entity;Value")

Shared connection:

HsCurrency("WSFN|ProviderType|Server|Application|Database,EntityMember;ValueMember")

Note:

Hyperion Enterprise does not use the Value dimension

Example

In this example, HsCurrency retrieves the entity currency where the currency for the East Sales entity is USD, and the currency for the UKSales entity is GBR. The EastSales entity displays USD, and UKSales displays GBR.

Private connection:

HsCurrency("Comma","Entity#EastRegion.EastSales;Value#<Entity Currency>.")
HsCurrency("Comma","Entity#EastRegion.UKSales;Value#<Entity Currency>.")

Shared connection:

HsCurrency("WSFN|HFM|hfm_svr|Comma|Comma","Entity#EastRegion.EastSales;Value#<Entity Currency>.")
HsCurrency("Comma","Entity#EastRegion.UKSales;Value#<Entity Currency>.")