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

 

Using data in dimension to distribute data in another element in same dimension

Started by ole, 20 Sep 2011 04:49:28 PM

Previous topic - Next topic

ole

Hi,

I have a cube with 2 dimensions.

DIM 1
CAR1
CAR2
CAR3
SUM CARS

DIM2
PRICE CAR
Forecast PRICE CAR

I would like to send a fixed value into element SUM CARS/PRICE CAR . If no input is done in element Forecast PRICE CAR I would like to use a brake back function. So far so good, this I manage to solve.

However if the user enters values in the element Forecast PRICE CAR I would like this to be used as a input for how the element PRICE CAR should divide the fixed total. So if I for car 1, 2 and 3 enter the values 100,200 and 700 (100+200+700=1000) in Forecast PRICE CAR I would like the total in the element PRICE CAR (for this example we can say the total is 100, this value is sent from another cube) to be distribute out accordingly to the values in Forecast PRICE CAR. Meaning PRICE CAR for CAR 1 would have the value 10 (1000/100 =10% * 100). For CAR 2 in element PRICE CAR I would have the value 20 (1000/200=20%*100) and for CAR3 the value 70 (1000/700=70%*100). I have solved this using an internal d-link, but then I have no possibility to change the values in PRICE CAR after the values are sent in through the d-link. I would like to have the possibility to change the column price car after the split is done as this is only done to give me a starting point.

Was that understandable?  :) And is it possible to solve?

Really appreciate all answers!

Regards
Ole