HsCurrency

Data sources: Financial Management, Hyperion Enterprise

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

Syntax

HsCurrency (“Connection,Entity;Value”)

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.

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