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

Virtual Cube - Currency Help

Started by SPTuco, 08 Jul 2015 02:52:41 AM

Previous topic - Next topic

SPTuco

Hi,

Does anyone have knowledge or documentation on how to implement currency conversion calculations in Dynamic Cubes.  I am looking for functionality similar to what we have in Transformer.

In the Dynamic Cube Redbook I can find the following information

"To address this problem, you can create a cube named CurrencyExchange to store the
exchange rates to keep the Global Sales cube unchanged, and you can then define a virtual
cube named SalesConversion to handle the currency conversion for the sales data. The
GlobalSales and CurrencyExchange cubes share some dimensions, such as Time, but they generally have different structures. "


I've not been able to find any further documentation or examples of this technique.

I have created the second cube but i'm a bit stuck on getting a virtual cube to handle the calculations.

Thanks in advance.

S.

SPTuco

I managed to find what I needed.

For reference the the latest Dynamic Cube Red Book 10.2.2 dated June 5th 2015 has padded out the information and includes instructions on currency conversion with Virtual Cubes. Which was absent in the first edition.