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
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.
Hi,
Thanks for your reply. I managed to get this working by using internal d-links.
Thanks again