TM1 Forum

Hello All,

I have a requirement to copy data from one cube dimension element into a different cube but divide the data among different elements of a dimension.
In case that's not clear, Say in Cube ABC, I have 'amount' 100 for 'Department ID' 001. I want to load this 100 amount into my another cube XYZ
for 'Department ID' 001, but divide it(100) equally for each employee (in Employee dimension) (say 5 employees are in Dept 001). So Emp1 will have amount 20, Emp2 will have 20 and so on..

My current situation is, I am able to load 'amount' 100 for Department ID 001 from cube ABC into cube XYZ for Department ID 001, but its 100 for each employee.Which Is not right. I want 100 to get divided among employees for each Department ID.
The data in Cube XYZ should be like this : (But currently it's 100 for each employee in Department 1)
Amount
Department ID Employee
1 10001 20
10002 20
10003 20
10004 20
10005 20

Can you give me a hint how to do it using TI.
Thanks.

Hi jgd108,This might help.

http://www.tm1forum.com/viewtopic.php?f=3&t=9643 Thanks

Hi jgd108,

create an attribute for each employee as 'Dept' (which will store which dept an employee belong to)
create an attribute 'Noofemployee' in Dept dimension, to store information about no.of.employees in a department. ( this can also be stored in a cube)

Now, following rule could be used in Cube XYZ

['Amount'] = N :
IF( !Dept @= ATTRS('Employee',!Employee,'Dept'),
(DB('ABC', ATTRS('Employee',!Employee,'Dept'),'Amount') ###: this will give Total amount of that dept to which an employee belong to.
/
ATTRN('Dept',!Dept,'Noofemployee') #### : this will give no. of employee in that department.
),0);

Assumption: Cube ABC have only 2 dims - dept and measure dim.

I may be quite off the mark here but you could also try this,take a view as a source and you could input the value by using CellGetN and then distributing the retrived value by using function CellPutProportionalSpread for example : CellPutProportionalSpread( value, cube, e1, e2, e3...,en ); Thanks