Copying data b/w cubes of different dims - Incremental load

[ashwinchitkara]

Hello All,

I am trying to copy data from a 10 dimension cube to a 5 dimension cube using TI process. Since I loose out unique slices due to less number of dimensions within my second cube the TI process over writes / replaces similar records while loading resulting in only a portion of records/slices being loaded.

Is there a script that I could include within the Data/prolog tab which would add records instead of over-writing? in other words perform Incremental load.

Thanks,

Ashwin

[Olivier]

Hi,

I think you probably use only CellPutN to populate your values in the destination cube.

This result with the latest record corresponding to the dimensionnality beeing stored.

TO accumulate data you will need to use :
CELLPUTN ( Value + CELLGETN ( 'cube', dim1, dimn ) ,'cube', dim1, dimn ) ;


Hope this helps,

[qml]

... And in case you are using the TI wizard to generate your script and not writing it yourself (which I wouldn't recommend except for the simplest of cases, but hey, you're the dev), you need to make sure you choose the Accumulate Values radio button in the Data Action section of the Maps - Cube Tab. The result will be the same as described by Olivier, namely before writing something to a cell its contents will be read and added to the value being loaded.

[David Usherwood]

Just to stir the pot a little.
Do you have totals on the dimensions you are summarising?
If you do (and you ought to) you might find a rule- and feeder-based approach better. Just feed (conditionally if you need to) from the totals in the source cube to the detail in the target, then rule the totals in the target from the source. Then you don't have a process to run and the users can see where the numbers come from.

[ashwinchitkara]

Thank you all for your quick response. Its working ...

Thank you again for your help. This forum rocks.... =D