数据源:Financial Management、Planning;Hyperion Enterprise(仅限专用连接)
HsCurrency 检索指定维成员的货币值。HsCurrency 函数的有效成员只有 Entity 和 Value。
专用连接:
HsCurrency("
PrivateConnectionName
,
Entity
;
Value
")
共享连接:
HsCurrency("WSFN|
ProviderType
|
Server
|
Application
|
Database
,Entity
Member
;Value
Member
")
注: | Hyperion Enterprise 不使用 Value 维 |
在本例中,HsCurrency 将检索实体货币。其中 East Sales 实体的货币是 USD,UKSales 实体的货币是 GBR。EastSales 实体显示 USD,而 UKSales 显示 GBR。
专用连接:
HsCurrency("Comma","Entity#EastRegion.EastSales;Value#<Entity Currency>.")
HsCurrency("Comma","Entity#EastRegion.UKSales;Value#<Entity Currency>.")
共享连接:
HsCurrency("WSFN|HFM|hfm_svr|Comma|Comma","Entity#EastRegion.EastSales;Value#<Entity Currency>.")
HsCurrency("Comma","Entity#EastRegion.UKSales;Value#<Entity Currency>.")