Some businesses need to see the same results in a different currencies, for example a sales manager needs to see the same regional sales by different currencies for each region.
First, create a simple conversion table in Excel:
Now add this as a table in the ElastiCube manager. (You don't need to connect it to any other table)
Select
Build Schema Changes and open Prism
Create a Pivot, then drag a dimension onto the rows and drag some amount Measure onto the columns.
Now, add the two dimensions
(Currency, Value) from the Excel table on two Disconnected Members Pickers.
Connect the Value picker to the Currency picker via the Dynamic Input such that every time you select a currency, the value changes.
Rename the Values picker to curr (Right click -> Rename)
Now here is the interesting part, you are going to use the Parameters feature to apply a measure calculation on the Pivot measure, To do so, click on the Pivot measure and edit the formula on the top:
[Measure] * [@curr] (Where [@curr] is our parameter)
Now every time the user selects a currency, the values picker changes and changes the pivot result.