Cost allocation with TI

[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

[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...

[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

[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.

[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

[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.

[ARNOJ]

To complete my answer

I have done :

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

then
CellIncrementN (ValueResult, CubeResult)