COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: tazman on 06 Aug 2007 02:20:35 PM

Title: Some layout advice
Post by: tazman on 06 Aug 2007 02:20:35 PM
I just took over an account that has a monster install of Planning.  Basically they have 32 applications for every instance of Cognos Planning (Budget, Forecast etc). The reason for this is conversion. They want to see everything in the countries local currency along with USD. Everytime there is a change I basically have to make it 32 times. Right now I am drawing a blank as to best way to consolidate it. I would like to do something like Europe, Asia Pac, Amercia's etc. The problem is Japan has a different conversion rate than say Korea. Any ideas, I know there has to be a better way of consolidating this
Title: Re: Some layout advice
Post by: ykud on 19 Aug 2007 02:59:18 AM
Can you do just 1 app with {Base Currency - USD - Conversion Rate Dimension} dimension and load appropriate rates for each country (elist items)?