If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Currency Conversion in Planning?

Started by Radhika, 26 Mar 2009 10:48:28 PM

Previous topic - Next topic

Radhika

Hi All,

I would like to know how we handle the currency conversion in planning?

Is it possible to load this data automatically into Planning application and perform the currency conversion. If possible please provide the solution.

Our company operates from different parts of the world such as US, UK, Australia, New Zealand, Singapore and Dubai.

For Ex:

From_Currency To_Currency Factor
AUD USD 0.7



1.In the above scenario we want to convert all the currencies in to $US. So how can we apply exchange rates?

2. And another thing when a user logs in webclient level he has to see only currency to the country which he belongs to...

Do we need to create a separate D lists, D Cube and D links for this scenario...

Can anyone give their ideas, its very urgent.


Thanks in Advance...


Welcome to open discsuuions.... :)

Radhika

cbrandt

Hi Radhika,

Lets assume you do cost center planning and have a few cubes in there (Travel, Staff cost and an OpEx Summary).
First of all, I usually prefer to keep the currency conversion only to a final summary cube where you have all accounts.

I would set it up as follows:
Include a new DList in the summary cube with the following items:
- Local Currency
- Local Currency Flag
- FX Rate
- USD

In Contributor you would hide all items but the Local Currency (and maybe leave the USD as Read-only)
The Local Currency Flag should be DList formatted and should be populated via backend process from the Administrator, whenever the Cost center hierarchy is updated.
You then set up a simple Assumption cube with the DList that is used for the Local Currency Flag and enter the FX rates in there.
You can then set up a Lookup Link to load the FX Rate into each account in the Summary cube.
And the USD item in the DList is a simple calculation of Local Currency * FX Rate.

Hope that example helps. setup may vary as per requirements, but that should give you an idea.
Carsten

mrobby

There is a paper on Currency Conversion that I have downloaded.  It's pretty basic but Ill try to find the link.  It goes over mostly the way CBrandt is talking about doing it.

An alternative way to do this is to use another dlist in your cubes that has all the currencies in it and then use an assumption cube to bring in the FX rate based on the dilist item.  Then use access tables to only show the currencies you want to plan with based on your e list.

In our case we needed the ability to do centralized planning in US dollars as well as at a Local currency so I have a D list that has

Local Currency
FX Rate
US Dollar

The US Dollar item is always constant so I can make changes in US dollars and it breaks back into local currency.

Almost the same as what CBrandt is saying but I have to do the conversion in each cube in order to have the ability plan in US dollars and Local Currency.  The summary cube is only loaded with Local currency and the FX in summary is calculated there.