Analytics Software

I am looking for a function in Financial Reporting Studio that operates the same as the HsCurrency function in Smart View. This would allow batch reports displaying the currency value of the User POV for Entity based on the User POV for Value. Right now I have to have Member Lists for separate reports and different currencies as I am only able to display the Value dimension in the heading of a given report. Users will not be certain of the currency if the Value dimension is <Entity Curr Total>.

I tried the HFMCurrency text function, however the entity is not defined in a Row / Column / Page reference as the entity is determined by the User's Point of View.

Is there a way to display the currency value of a User's Point of View for Entity based on the User's Point of View for Value?


Reference from Oracle Hyperion Smart View for Office, Fusion Edition, User's Guide:

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”)

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>.”)