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
Credit cost allocation
-
- Posts: 25
- Joined: Mon May 20, 2019 9:54 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: Credit cost allocation
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
Thank you all