allocating values from one cube to another cube.

[ravi.ahuja21]

Hi friends,

I have a cube named HR,
Having following dimensions.
Function,
Facility,
Scenario,
Serial No(1,2,3,4)
Department
Account Code,
Measures-Employee Name,Allocation %,Amount, Allocated Department, Allocated Account Code.


The design is some employees are working in different department however the budgeting for them happens in the same department and it gets allocated across different department as per the allocation % specified.

For EG Employee A belongs to IT Department, but he also works for Finance department hence the allocation should be 50% for IT and 50% for finance in the P & L cube.
Note:The budgeting for this employee would be done under the IT department only and it should automatically allocate it.



My problem is that once the user is done with entering the HR budgets, it should go and hit the P & L cube to its respective Account Code and respective Department.

Currently I am doing it using a nested while loop, however there is too much of code involved.

I am trying to export the cube as a text file and import it back to the P & L cube but whenever I try to export the cube the process terminates unexpectedly.

I am not sure if I am on the right track,Is there any simple way in which i can achieve this?

[jim wood]

I'm not sure this is technical problem with TM1? If you have rules / TI scripts that you are having a problem with please post them and we will help you where we can.

[tomok]

If you are exporting a cube did you make sure to suppress zeros in your view? If not, your export is likely to crash your server. This is a comon mistake by newbies.

[ravi.ahuja21]

Thanks Tom, I will try by suppressing zeroes.

Hi Jim,

Thanks for the reply, I am a newbie so I was just asking if the approach adopted is alright, or is there any other way to do such things.

[Steve Rowe]

You'd often use rules to do this kind of simple allocation, in pseudo code this looks something likes this.


[Allocated Head count]=N: [Input Headcount] * DB ( Departmental allocation rates);

If you are using TI to do this it may be a bit of an overkill plus with rules you will get your results in real time.

Cheers

[jim wood]

Thanks Tom, I will try by suppressing zeroes.

Hi Jim,

Thanks for the reply, I am a newbie so I was just asking if the approach adopted is alright, or is there any other way to do such things.

Hi Ravi,

I miss read the last 2 lines of your post. Apologies.

[ravi.ahuja21]

Hi Jim,
It's ok, Thanks for your time appreciate that.

[ravi.ahuja21]

You'd often use rules to do this kind of simple allocation, in pseudo code this looks something likes this.


[Allocated Head count]=N: [Input Headcount] * DB ( Departmental allocation rates);

If you are using TI to do this it may be a bit of an overkill plus with rules you will get your results in real time.

Cheers

Hi Steve,
Thanks for the valuable inputs & time.