I have a requirement where the user wants the amount in different currencies based on the user input.
In the cube I have Amounts in LC, DC, LC2, LC3 and Currency keys - 0LOC_CURR, 0LOC_CURR2, 0LOC_CURR3, 0DOC_CURR.
The user should be given an option to select on of the above mentioned currency keys...
Pls note that the requirement is not that he will be inputing values like - USD or INR or any such hard coded values. He should input one of the above mentioned currency key and the ouput Amount should display all the currencies maintained for that currency key.