Forum Discussion

NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

Displaying currency in a cube view for a Balance account

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. Thin...
Methodology
  • EricOsmanski's avatar
    EricOsmanski
    3 years ago

    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.

EricOsmanski's avatar
EricOsmanski
Valued Contributor
3 years ago

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.