Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

CVs that list the currency belonging to a company

Originally posted by Felipe Alcorta

We have quite a bit of entities across many currencies.  Is there a way to incorporate into a CV the associated currency (found in the currency setting of the member props) for a specific entity?

1 Reply

  • Yes, the currency of the Entity can be incorporated into Cube Views.  The easiest way is to turn on Show Currency in the Cube View Properties.

    Steps to turn on Show Currency:

    1.  In the Cube View, click on the Cube View Properties tab

    2.  Under Formatting > Cell Format, click on the 3 ellipsis dots.  

    3.  Click on Format...

    4.  Under Amount > Show Currency, click on the drop down to select True

    This will now show the Entity Currency for each values cell if the Consolidation member is set to Local in the Cube View.