Cost allocation with TI

Post Reply
ARNOJ
Posts: 18
Joined: Tue Oct 08, 2013 2:24 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010 SP1

Cost allocation with TI

Post by ARNOJ »

Good morning,
I have the following question to do in a turbo integrator process for my cost allocation
Base on the following :

Cube Source which contain
Dim1_Source
Dim2_Source
Dim3_Source
Value of the Cube : amount

CubeRules Calculation which Contain
Dim1_Source
Dim2_Source
Dim3_Source
Dim4_Mapping
Value of the cube : Percentage

CubeTarget which Contain:
Dim2_Source
Dim3_Source
Dim4_Mapping
Value of the cube : Amount Cube* Percentage

In my process, I have put in prolog my cubesource with all the level 0

My issue comes with the to the data tab.

I need to the mapping before doing my cellincrementN
Dim4_Mapping.CubeTarget
= Dim4.CubeRules when it see the value of Dim1_Source.CubeSource, Dim2_Source.CubeSource, Dim3_Source.CubeSource

Can I use a DB Function or a Cellx Function ?

Thanks You

ArnoJ
Please note that English is not my native language.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Cost allocation with TI

Post by rmackenzie »

Why don't you just state the business problem and the real dimension name - you're not giving anything away if you have accounts and business units etc like almost everyone else does. By presenting the question as a 'homework' problem, you're making it hard for people to give you answers because it is so abstract...
Robin Mackenzie
ARNOJ
Posts: 18
Joined: Tue Oct 08, 2013 2:24 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010 SP1

Re: Cost allocation with TI

Post by ARNOJ »

I present then as homework as it is easier for me to express them.

I try to redo it again

Good morning,
I have the following question to do in a turbo integrator process for my cost allocation
Base on the following :

Cube Source which contain = Data for GL System
Dim1_Source - Account
Dim2_Source - Activity
Dim3_Source - Domain
Value of the Cube : amount

CubeRules Calculation which Contain = Allocation Mapping and allocation Key
Dim1_Source - Account
Dim2_Source - Activity
Dim3_Source - Domain
Dim4_Mapping - Activity by Cost
Value of the cube : Percentage

CubeTarget which Contain The result of the allocation
Dim2_Source - Activity
Dim3_Source - Domain
Dim4_Mapping - Activity by Cost
Value of the cube : Amount Cube Source * Percentage CubeRules

In my process, I have put in prolog my cubesource with all the level 0

My issue comes with the to the data tab.

My question is how I can mapped the data in the CubeTarget (result) knowning that the mapping Dim1_Source - Account * Dim2_Source - Activity * Dim3_Source - Domain = Dim4_Mapping is not actually store in TM1

Dim4_Mapping.CubeTarget
= Dim4.CubeRules when it see the value of an intersection of Dim1_Source.CubeSource, Dim2_Source.CubeSource, Dim3_Source.CubeSource from the CubeSource (accounting GL)

Can I use a DB Function or a Cellx Function ?

Thanks You

ArnoJ
Please note that English is not my native language.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Cost allocation with TI

Post by rmackenzie »

So you're storing the mapping between Accounts and Activities outside of TM1? And you want to tap into this data set when you run the allocations? And you are wondering if you can use a DB() or CellGetN() type formula to tap into a data set sitting outside of TM1? The answer is no to the last question.

You could point a TI at a table, or file, of mapping data and process each mapping. As you process each mapping you could perform the allocation.
Robin Mackenzie
ARNOJ
Posts: 18
Joined: Tue Oct 08, 2013 2:24 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010 SP1

Re: Cost allocation with TI

Post by ARNOJ »

I found my solution

the cube rules calculation contain all the dimension between the amount and the result.

Therefore in my TI I have the cubes rules as source in Prolog and then mapped it to the cube.sources and put the result in the cube.result

In my data tab, I have

ValueResult = Value Cube Rules (from Prolog) * CellGetN from SourceCube

it works
Please note that English is not my native language.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Cost allocation with TI

Post by BariAbdul »

In my data tab, I have

ValueResult = Value Cube Rules (from Prolog) * CellGetN from SourceCube

it works
Glad it worked out for you ,But I wonder this is all the code you have in Data tab,and how did you achieve it without CellGetN and CellPutN. ;)
"You Never Fail Until You Stop Trying......"
ARNOJ
Posts: 18
Joined: Tue Oct 08, 2013 2:24 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010 SP1

Re: Cost allocation with TI

Post by ARNOJ »

To complete my answer

I have done :

ValueResult = Value Cube Rules (from Prolog) * CellGetN from SourceCube

then
CellIncrementN (ValueResult, CubeResult)
Please note that English is not my native language.
Post Reply