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