Change currencies for any page using a dimension

Description

This feature enables users to view and analyze financial data in any currency, for any combination of dimensions. This means that, when looking at any report, worksheet, or visualization, the user can select an alternative currency and view the results immediately.

Example Use Case

Scenario: A multinational corporation uses CPM software to manage its financial performance across multiple countries. The company operates in regions that use different currencies like US Dollar (USD), Canadian Dollar (CAD), and Mexican Peso (MXN).

Solution: By using the currency change function, the CPM software allows for the dimension Region to be viewed in any currency. For example, the Mexican location can be represented in USD, CAD, or MXN. This way, it becomes easier for the users to interpret financial data in the context of the region's local currency or their own currency.

Considerations

The core concept of this requirement is making currency just another dimension, meaning that the model requires no special calculations or treatment when the user needs to view or enter something in their currency. The big benefit here is that users can view reports in a currency familiar to them. They're not having to convert the amount on Yahoo Finance every time they need to contextualize a value.

This also allows Currency to be pivoted, placing them side by side in a report for everyone to understand.

Questions to Ask a Vendor

• Currency as a Dimension: Is currency in your product treated as a dimension or do you manage currency in a different manner? If so, what are the positives and negatives of your approach?
• Adding a Currency: If we add a new currency, will it show up automatically on all sheets and reports?