Allocating Costs to a different cube

[hpansar]

Hello,

I need to understand how to build a TI that will do the following:

cubesource = Cube A
cubetarget = Cube B

the dimensions in Cube A are:
View
Version
Entity
FiscalYear
Measures (Cost)

the dimensions in Cube B are:
View
Version
Entity
Vendor
FiscalYear
Measures (Cost)

I am trying to create a TI that will take Cube A Cost data and allocate the data to Cube B. The difference is the Vendor dimension and I would like to spread the cost data from Cube A based on last year cost that is sitting in Cube B.

How would this be created as a TI or can this be done in a Rule.

thanks

Hiten

[tomok]

How would this be created as a TI or can this be done in a Rule.

As with almost anything TM1, it can be done with a TI process OR a rule. Your choice.

Rule example:

Code: Select all

[Cost]=N:DB(CubeA,!View,!Version,!Entity,'2013','Cost') * ['2012','Cost] \ ['All Vendors','2012','Cost'];

Don't forget the feeders.

TI Process:

This is a little more complex. You have a TI function called CellPutProportionalSpread that will do the trick for you. The problem is you have to have data already in the cube for cost in the current year in order to do the spreading. There is no relative proportional spreading in TI. Your steps:

1) Create a view in Cube B that has the cost data by vendor for 2012.
2) Load that into Cube B as 2013.
3) Create a view in Cube A that has cost data for 2013
4) Load that into Cube B for 2013, except instead of using CellPutN, use CellPutProportionalSpread and for the reference to the Vendor dimension, use the element 'All Vendors'.

The only caveat here is what to do when you have costs in 2013 but not in 2012 (nothing to allocate on) or costs in 2012 but not 2013 (you'll be left with 2012 costs sitting in the 2013 element). You'll have to take both those conditions into the equation.

Hope that helps. Good luck.

[hpansar]

Thanks so much Tomak