Hi All,
Could you please share the TI script for copying data from one scenario to another one scenario.
Regards,
Raj
TI Script need for copying data from Scenario to scenario
-
qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: TI Script need for copying data from Scenario to scenari
You do realise that generally speaking a TI script doing that in some other TM1 model would not work in your model?
You can try and write this script yourself as it's the most basic of tasks for which TI can be used. If you don't feel you have enough skills for that then you probably should think of a basic course on TM1 development before posting questions here.
You're not telling us if this should be a one-off load or a process that will be used multiple times for different data ranges (periods etc), so it's impossible to talk about details, but the most obvious approach is to create a source view containing your source version and then use the CellPutN / CellPutS function(s) on the Data tab to write the values to the target version. Depending on your requirements you might also want to zero out your target area before the load takes place.
You can try and write this script yourself as it's the most basic of tasks for which TI can be used. If you don't feel you have enough skills for that then you probably should think of a basic course on TM1 development before posting questions here.
You're not telling us if this should be a one-off load or a process that will be used multiple times for different data ranges (periods etc), so it's impossible to talk about details, but the most obvious approach is to create a source view containing your source version and then use the CellPutN / CellPutS function(s) on the Data tab to write the values to the target version. Depending on your requirements you might also want to zero out your target area before the load takes place.
Kamil Arendt
-
paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: TI Script need for copying data from Scenario to scenari
Hi
I can tell you that it is possible to write TI scripts that will do this, and will cope with any cube regardless of the number of dimensions, and that will allow parameters to select eg a version in combination with a range of periods, etc. However, developing these was not free, so they cannot be shared free.
As a few pointers, you will need to cope with the fact that cubes may have numeric and string values, and that the destination cube may calculate somethings by rules, which will prevent overwriting. Also the position of the version/scenario element may be different in different cubes.
Regards
Paul Simon
I can tell you that it is possible to write TI scripts that will do this, and will cope with any cube regardless of the number of dimensions, and that will allow parameters to select eg a version in combination with a range of periods, etc. However, developing these was not free, so they cannot be shared free.
As a few pointers, you will need to cope with the fact that cubes may have numeric and string values, and that the destination cube may calculate somethings by rules, which will prevent overwriting. Also the position of the version/scenario element may be different in different cubes.
Regards
Paul Simon