HsCurrency

Describes the Smart View function, HsCurrency.

Data source types: 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")

URL connection

HsCurrency("URLFN|URL|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>.")

URL connection:

HsCurrency("URLFN|https://<servername:port>/hfmadf/../hfmofficeprovider/OfficeProvider|<servername:port>|Comma|Comma","Entity#EastRegion.EastSales;Value#<Entity Currency>.")