Delete overlapping requests of same DTP from cube

[Former Member]

Dear All,

i want to delete over lapping requests of same DTP in cube, but here while i am searching for the DTP in process variant, the system is not showing the DTP(it is active).

can you people have any suggestions.

Br,

Vamshi.

[Former Member · Accepted solution]

Hey Vamshi,

Is your DTP a full one or delta one ? Delete Overlapping reqs is not possible for Delta loads.

In Load Process and Post-Processing option you will find Delete Overlapping Requests from InfoCube, drag and drop and make the following settings:

Object Type = DTP

Object Name : DTP Name.

Check Edit all InfoCubes with the following Delete Selections and click on Delection Selection

Check Delete Existing Request and check Only Delete Req from same  DTP

Activate and execute the PC.

Hope this helps!

Sheen

[Former Member · Accepted solution]

Hi Sheen,

DTP is delta not full, so you mean to say that deleting overlapping requests of delta DTP not possible.

regards,

Vamshi.

[Former Member · Accepted solution]

yes, you cannot delete overlapping requests for DELTA DTPs as delta essentially means NEW data which has to come from the last time the pointer was set.

While overlapping requests means that the requests which have same data (which is the opposite of DELTA). You will note that DELETING OVERLAPPING reqs is only for cubes for corruption of data (this can happen only in full loads due to additive nature of cubes as DSOs inherently overwrite).

You wont need to do a overlapping req deletion for a DELTA DTP.

Hope this helps!

Sheen

[RamanKorrapati]

Hi,

While defining selections for that process, you need to choose DTP as object type.

Thanks

[Former Member]

Hi Korrapti,

i selected the same, but here in next column object name the DTP is not available in the list after pressing F4

[RamanKorrapati]

Then am guess your dtp will be the delta one. if yes then not possible.

deleting overlapping request will for only full loads.