TM1 Forum

Hi,
I need to understand if I can do something in TM1. I have three cubes: Actual, Scenario Properties and PriceandCost.
I put a rule in the PriceandCost cube: ['Forecast']=N:IF(DB('Scenarios_Properties',!Años,!Periodos,'Forecast','String')@='A',DB('Actual',!Años,!Channels,!Periodos,!Productos,'Actual','Costo Unitario'),0); because I want to bring me data of the Actual cube if the Scenario Properties cube have A values. The following picture presents what I do: My problem is I don´t want to do this through rules but I want to do it from another way, for example through a TurboIntegrator processes because i want to make generic and not for a particular cube.
How can I put in Turbo Integrator in Prolog? or in another way?

Thanks in advance
Regards

please can you tell me if you didn't understand the problem or don't know
thank you very much

You can do it in Turbo Integrator, but it would also be a seperate process for each cube.
In TM1, all rules and data transfer processes are defined specifically for each and every cube.
Therefore I am not sure if you can reach to such a generic solution in TM1.

Hello,

just a couple of thoughts.

- the choice between rules and Turbo Integrator will most of the time be based on: do the results have to be calculated on the fly? or are you happy that someone runs a process / a process is scheduled at specific times. Do you have other logic that you cannot easily translate into rules?

- writing TI processes for generic cubes is not easy. For one thing, the variables tab will have difficulties if you change dynamically from cube to another cube, and the dimensions are different. How dynamic should this be?

In any case, as I see it now, go for the rules solution ...

Wim