TM1 Forum

Hi All,

I have two cube 1 Profit&loss cube (pl) second allocation or mapping cube.

Pl i have 8 dimensions
Mapping cube 4 dimensions

In pl cube debit side is rule calculated and i have employees who occur this cost and a corporate to whom i will allocate the cost in credit side.

Now suppose there is a employees codes(dim) 1101
I want to allocate its cost to other corporate employees codes(dim) 9111,9112,9113.

So in my mapping cube i have flagging as well as percentage of cost to allocate
Dimensions in context cost dimensions and measure dimensions.
I have created employees dimensions two one with 1101 elements and one with 1101. Elements because i have to allocate my expenses in the same dim but to different employees codes.
9111. 9112. 9113.
1101 Y|.25 Y|.35 Y|.40

I have made a ti in which i have selected the data source as p&l.
So i have 8 variable plus i have employees code dim in it.
But i dont have employees code other dimensions carrying 1101. In my variables created it through concetenation with employees|.

When i now doing cellgets to retrieve Y in mapping dimensions.

Cellgets(mapping cube,1101,9111.,cost,flag);
When taking ASCII of it due to data source cube is heavy it's reading in lakhs the data and plus it's not retrieving the flag.

What should i do.
I tried it through rule also but it not possible there also i think doing it with ti will be best.

Thank you all

If there is 1000 in combination of 1101 in debit side it should cellputn the 1000 in % wise in 9111. Credit side eg.(250).9112. Credit side eg.(250).9113. Credit side eg.(500). In this 3 combination how should i proceed further.


Thank you all