TM1 Forum

I am new to TI so may be the help request is an easy one. I sure hope so

I have 2 cubes with source Data - ProductionPlan and Technology.

ProductionPlan cube defines which product will be produced by each plant, and the Quantity to be produced:


Tecnology cube defines the numer of Components of each type required to produce 1 product of each type:


My Target cube is ComponentDemand. I want TI to check, wich product will be produced, take it's Tecnology data, multiply it by Quantity to be produced and put it into cube:


How do I do it in the best possible way?

I have a reason not to use rules here, TI is essential. I need my target cube to remain editable after data transfer.

I would also like to avoid creating extra cubes, those listed above will be huge and require a lot of resources to calculate.

Cog1 wrote:I have a reason not to use rules here, TI is essential. I need my target cube to remain editable after data transfer.

Let me start by challenging this statement. You can have an additional version-type dimension in the cube, where one element will be rule-fed, another manually editable and both will consolidate to give the overall result. Users would simply input adjustments to amend what the general rule calculates. Alternatively, their input could override the rule calculation altogether instead of being added to it. It's quite simple to do.

Achieving what you want in TI is quite straightforward. One of your two source cubes needs to be your Data Source, or rather a view of one of them. Then on your data tab you need to get the extra information from the second cube using CellGetS/CellGetN statements, prepare the data to input and CellPutS/CellPutN it to your target cube.

Let me know if you need any more detailed guidance, but this should get you started.

qml wrote:Let me start by challenging this statement. You can have an additional version-type dimension in the cube, where one element will be rule-fed, another manually editable and both will consolidate to give the overall result. Users would simply input adjustments to amend what the general rule calculates. Alternatively, their input could override the rule calculation altogether instead of being added to it. It's quite simple to do.

Thank you for this very reasonable addition, I considered it too. My secondary objective here is to learn TI, so I'll stick with the task the way I put it above.

Achieving what you want in TI is quite straightforward. One of your two source cubes needs to be your Data Source, or rather a view of one of them. Then on your data tab you need to get the extra information from the second cube using CellGetS/CellGetN statements, prepare the data to input and CellPutS/CellPutN it to your target cube.
Let me know if you need any more detailed guidance, but this should get you started.

I will check CellGetS/CellGetN and CellPutS/CellPutN statements and try to get what I want. If I need additional help - I will ask here.

Thank you very much for a prompt reply