Skip to main content
N
NidhiMangtani
Veteran
July 25, 2022
Solved

Displaying currency in a cube view for a Balance account

  • July 25, 2022
  • 1 reply
  • 0 views

Hello All,

I want to display the default currency value for specific entities in a cube view. Account being displayed is of type Balance so ShowCurrency setting fails to display currency here. Thinking of writing a XFBR rule to pull currency and display custom names in the rows along with Entity names. Is there a better alternative to achieve this?

Any leads would be appreciated.

    Best answer by EricOsmanski

    You should be able to use XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency) instead of an XFBR. Alternatively, if you wanted it in a cell, you could create a UD8 member to pull Entity currency and have a column showing the currency. It depends on what the report should look like.

    1 reply

    E
    OneStream Employee
    EricOsmanskiOneStream EmployeeAnswer
    OneStream Employee
    July 25, 2022

    You should be able to use XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency) instead of an XFBR. Alternatively, if you wanted it in a cell, you could create a UD8 member to pull Entity currency and have a column showing the currency. It depends on what the report should look like.

      Terms & ConditionsAccessibility statement