HsCurrency

数据源: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>.")