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

[Basic?] Calculation between dimensions - how?

Started by ole, 15 Sep 2011 07:32:58 AM

Previous topic - Next topic

ole

Hi,

I have tried searching the forum but I have not found a solution to my problem. I guess the solution is quit easy but I cant get my head around it.

I have 2 dimensions that consists of several elements. For instance:

DIMENSION 1
Car 1
Car 2
TOTAL

DIMENSION 2
Net sales
Qty
% of total net sales

I would like to know how many % of Net Sales Car 1 is resposible for based on the TOTAL.  So if Car 1 has a net sale of 80$ and Car 2 has a net sale of 20$ I would like to hvae the element "% of total net sales" calulate 80% for Car 1 and 20% fo Car 2. So I need to divide Net sales for Car 1 and 2 in dimension 2 on the TOTAL in dimension 1. How can this be done? :)

Regards,
Ole

ericlfg

Hey Ole,

I'll take a stab at this..  if anyone else has another, easier, way of doing this please reply..

I think the only way you can get this to work is to create an internal d-link to move dimension 1 data to dimension 2 (assuming both dimension 1 and 2 are present in the same cube?)  I believe this is necessary as you're trying to build a calculation in dimension 2 with values contained in dimension 1.  You will need to create staging dimension members in dimension 2 to be the target of the d-link from dimension 1.  This is so you can build the calculation against the data moved into dimension 2 by the link.

I haven't tested this..  but maybe it'll point you in the right direction.

ole

Hi,

Thanks for your reply. I managed to get this working by using internal d-links.

Thanks again