TM1 Forum

Hi,

Can anyone help me in sorting out this issue.

My users wants to spread data based on the % of proposed Totals.

These are the actual % for No.of Liftings in a month for a set of regions.
Region 1 - 22.18%
Region 2 - 67.20%
Region 3 - 5.41%
Region 4 - .08%
Region 5 - 2.54%
Region 6 - 1.70%
Region 7 - .88%
Note: Total No.of Liftings for a month is 4379

If the user wants to change to any percentage let say
Region 1 - 21.00%
Region 2 - 40.00%
Region 3 - 9.00%
Region 4 - 6.00%
Region 5 - 7.00%
Region 6 - 9.00%
Region 7 - 8.00%
Using the same total no.of liftings for a month, which is 4379; How can I spread the values to the leaf level based on given/changed %?

Is there any function or have to write TI which calculates the proportional values based on the given/changed %? Please guide me.

Thanks in advance.

you want to spread region data, maybe is a way using TI, but if you use a rule?

on a premises cube you have the total number of liftings and on the target cube a % measure and a output measure, having

['Output']=N:DB('premises','Total Liftings',.. other dims..)*DB('target cube',!region,...other dims..,'%');

every times % changes data changes, if you want to keep a result you can copy data to another version using a relative

hope it helps (If I understood your problem)

Cam wrote:you want to spread region data, maybe is a way using TI, but if you use a rule?

on a premises cube you have the total number of liftings and on the target cube a % measure and a output measure, having

['Output']=N:DB('premises','Total Liftings',.. other dims..)*DB('target cube',!region,...other dims..,'%');

every times % changes data changes, if you want to keep a result you can copy data to another version using a relative

hope it helps (If I understood your problem)

Thanks Cam, I got it and it is working fine.