Sam-
Currency conversion is a pretty straightforward thing in BW. Look here. [SAP BW Currency translation Help File|http://help.sap.com/saphelp_nw70/helpdata/en/ec/076f3b6c980c3be10000000a11402f/content.htm]
As to the effects of multiple company codes on currency and the overall scope of a consolidation of company codes, the big question is... will you want to CHANGE your historical information, or is the consolidation a 'from this point forward' question ?
If the answer is "From this point forward", then the short answer is you don't need to do ANYTHING.
That's right. Nothing. All transactions are already in your system for that company code, it will simply get all the transactions that used to be in the other company code. No worries.
If the answer is "I want history to reflect my new organizational structure", then prepare to ask a lot of painful questions. User ask for things like this all the time, and it's our job as BW analysts to refuse to do foolish things. And changing BW to reflect a new model of the world, while the source system maintains it's transactional integrity in the old model, is foolish.
Now.. they may want some queries to be changed to reflect the new reality. That's fine. You can do that. Just identify what queries and workbooks need to be changed and estimate the time to make the changes.
And good luck, and remember to leave yourself a way 'out' if they decide to 'undo' the change after some weeks or even years. Business decisions are often changeable, but properly managed data can be forever.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.