Skip to Content
0
Jul 07, 2009 at 11:04 AM

Delete data from cube

36 Views

Hello

I am held up in a situation and would appreciate your great help.

Explaining with an example

I have a load from a DSO to a CUBE. Now in the transfoirmation i have a start routine which says that if doc status is z then delete the source package.

So for eg : if i have 3 statuteses for a doc no. X, Y, and Z.

The start routine says delete source package wheere status is z.

so on the first day the doc no come with status X and goes into the cube. The next day it comes with status Y and goes in the cube. Now third day it comes with status Z and so doesnt load up.

Now what i want is that when the status is turned Z the X and Y status for the doc no. should be removed from the cube.

There is a option here to do a deletion and full load to the cube everyday but i want to consider another approach as data is too much.

Please help.

Thanks