Data sources: Oracle Hyperion Financial Management
Description
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")
For detailed syntax information, see Creating Functions Manually.
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>.")