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
Duplicate values on TM1
-
- Community Contributor
- Posts: 132
- Joined: Thu Oct 15, 2009 7:45 pm
- OLAP Product: TM1
- Version: 9.4.1 9.5 9.5.1
- Excel Version: 2003 2007
Re: Duplicate values on TM1
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.
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.
Ankur Jain
-
- Posts: 7
- Joined: Fri Apr 22, 2011 2:06 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Duplicate values on TM1
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
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
-
- Community Contributor
- Posts: 132
- Joined: Thu Oct 15, 2009 7:45 pm
- OLAP Product: TM1
- Version: 9.4.1 9.5 9.5.1
- Excel Version: 2003 2007
Re: Duplicate values on TM1
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.
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.
Ankur Jain
-
- Posts: 7
- Joined: Fri Apr 22, 2011 2:06 pm
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Duplicate values on TM1
Thank ajain86,
It works!!!!
It works!!!!