11-02-2020 08:33 AM - last edited on 08-11-2023 10:40 AM by JackLacava
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?
09-13-2021 08:43 PM
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.