Hello
In my report I have display two amount fields one is in GBP and same filed needed display in USD
I am storing the GBP amount field in my cube. But based one the current conversion rate I have to display the USD amount filed in the report.
I have created a new KF for that and added in the cube. I can write the routine in the transformation that will read the currency table and populate the find.
But the problem is, if I do that and store the record in Cube and run the report later the report will give wrong result. Because conversion rate might changed.
How to do that in the run time. If any one knows about the same please provide me the steps
thx
Samit