TM1 Forum

Hi, I try to copy the data within the same cube. But the result is not exactely what im looking for i would like to copy tha last actual month fto the upcoming months in the forecast scenario. The problem that my "if" statement doesn't work in the data tab. The result the data is copied fo...

Sorry i made a mistake:

if the actual month in Sys_Time is April, the process will copy all data from "Actual" to "forecast" from January to April
AND from May to December will be the data from the last month in "Actual" scenario which is April not July
Thanks

Thanks declanr for your response It works BUT the result is not exactely what im looking for I would like to copy all data from Actual scenario to Forecast scanario based on the actual month in the cube : SYS_Time for example: if the actual month in Sys_Time is April, the process will copy all data ...

Hi everyone New in TM1, i would like to create a process to copy data between scenarios within the same cube If the scenario is "Forecast", the TI will copy the last "Actual" Data & paste it for next coming month. For example if the "Actual"month is July, the proces...