Okay techies - here is what I have. Currency Conversion. I have done it in the transformer before rollups. I am looking to rollup some financial data monthly - and do a currency conversion on the same before the roll-up. I am looking for a solution in reportnet and/or Framework manager. Since the conversion needs to be done before the rollup - I guess it would best be done in the Framework Manager. Could you come up with any que-s or solutions - or even point me to where I may get some answers...
Thanks so much!
Damzi
I use the Date key in our time dimension to tie to our conversion table for that date. I then have a calculated field ConversionRate * ActualDollars(from our fact table) above the namespace containing the conversion table and fact table.
It is pulled together by using a conformed Time dimension.
CognosAustin, Thanks for your quick response. I am looking for a solution in the FrameworkManager/Reportnet. I am familiar with the solution in transformer/powerplay...
This was for FM.
I think Querry will be used for the user to select the currency to be displayed in the report. I have not yet encountered that but I have a lot of friends telling me it was good. Maybe I will be trying this soon.