Status:
New Idea
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Request: Provide a standard way for supporting multi-currency support.
Use Case: Enable end users to create widget and dashboards where they can switch between multiple currencies.
Background: There are various posts on how to implement multi-currency by adding an exchange rate dimension and using a formula similar to Local Amount = (Amount Field) * (Exchange Rate) and using a filter to select the desired currency (E.g. USD, EUR, GBP).
This process works well when you have dashboard designers, but it doesn't work well if you want end users to create their own reports. If they do things wrong the Amount may be multiplied by the number of currencies supported. They are required to enter a formula instead of simply selecting a field to report.
Recommended Solution:
Add ability to add Formula fields to the data Model. The data designer would create a standard field with the formula. The formula would be evaluated within the dashboard not during cube build. Note: there are probably other uses cases for data model defined Formulas that are evaluated within the dashboard.
Add ability for automatically adding the Currency filter when the data source is used.
See more ideas labeled with:
