Duplicate values on TM1

[Stephane]

Hello everybody,

I'm working on one project and i'm using TM1 9.5.1
i have one problem, i have two columns, budget and forecast, when i enter data in budget column , i want them to be automatically rewritten in forecast column and later have a possibility to manually modify

thk

[ajain86]

You can add an additional member called forecast adjustment which would be open for manual input.
Create a rule in the cube for the forecast element = budget + forecast adjustment.

Or you can use a TI process to copy over the data from budget to forecast, but this would require the process to either be run manually or on a time interval. It would not be instant.

[Stephane]

Thank ajain86

Please could you explain me how to implement the TI process to copy over the data from budget to forecasts please.
I have three dimensions: BU, Month, year, CR and and phase (budget, forecast and real)

Thk

[ajain86]

To copy data from 1 element to another, would you to create a view (either manually or using dynamic scripts) and then using that view as a datasource in a TI process.

Then in the data tab, as the process goes through each record in the view, you can utilize the CellPutN function to place the data that the process is reading into another cell.

[Stephane]

Thank ajain86,

It works!!!!