TI - Version Rollover: Current to Prior Fcst within cube

[jasonsacco]

TI (Turbo Integrator) based question:


I'm looking to utilize turbo integrator as a tool to roll data from one version to the next within the same dimension, and within the same cube. The dimension elements are: Current Forecast, and Prior Forecast. I'm not sure how the TI should be structured for this. I want to do this for multiple cubes.


Version 9.5, 64 Bit, Windows 2003 Advanced Server SP2,

Thank you all,

Regards,

[Alan Kirk]

TI (Turbo Integrator) based question:

I'm looking to utilize turbo integrator as a tool to roll data from one version to the next within the same dimension, and within the same cube. The dimension elements are: Current Forecast, and Prior Forecast. I'm not sure how the TI should be structured for this. I want to do this for multiple cubes.

Version 9.5, 64 Bit, Windows 2003 Advanced Server SP2,

One way is as follows. This assumes that there is nothing already in the target version.

• Create a subset consisting only of the Version element that you want to move data from, assuming that you don't need to limit this movement by any other dimension. (Your period dimension comes to mind.) If you do, you'll need subsets for those too. (SubsetCreate and SubsetElementInsert functions.)
• Create views in each cube using that subset / those subsets. (ViewCreate, ViewSubsetAssign and ViewExtractSkipZeroesSet functions, and possibly the CubeSetLogChanges function if you don't want to log the movement. Remember to set logging back on at the end if you need to.)
• Those views will become your data source for your movement processes, most likely one for each cube.
• In each cube's process:
  1. In the Prolog, specify the target version. (This could also be read from a control cube using CellGetS if you want to avoid hard coding it.)
  2. In the Data tab, use CellPutN to write the value sourced from your old version into your new version. The CellPutN function will use the version that you specified in your Prolog.
• Most likely, you'll want to zero out the values in the old version. You can use the views that you created as your data source for this along with the ViewZeroOut function.
• Destroy the views using ViewDestroy, and the subsets using SubsetDestroy.

That's it in a nutshell.