Base cube have 4 different keyfugres for Amount filed: Amount (LC), Amount (DC), Amount(GC) and Amount(4th) along with other fields. In other words all different currency types are appearing in the same row.
Design a BEx report, where user have the option to select currency type and accordingly report display selected currency type Amount field only. In other word dynamic selection of key figure is required.
Note: Cube do not have any Currency type field as there is no need to distinguish rows (as all currencies are appearing in same row).
Steps:
There are couple of other ways as well, like using calculated Key figure and a formula variable as below:
Note:
Although the sue of calculated keyfigure will have some impact on the report performance. But in scenarios where we need to use multiple keyfigures, using one global Calculated Keyfigurer along with a formula would be a better option.
Feel free to comment and share your idea(s).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
36 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |