How to delete overlapping request of Error DTP in Cube

[Former Member]

Hi,

My requirement is to delete all the existing overlapping Requests,Once Full load is done to Cube using process chain.

Existing Overlapping Requests might be FULL,Delta,Error DTP request.

Kindly provide me some Information on this.

Regards,

J.Sakthikumar

[Former Member]

hey Sakthi,

Overlapping requests essentially mean requests which have the same selection (meaning the data will be same).

When we load delta, the data that comes is new, as it does not bring the old data which has been fetched. Hence, you cannot do the delete overlapping of DELTA DTPs.  Overlapping req deletion works when you have a full DTP and you are loading to cube - as cubes are additive and loading same data twice will result in corrupt data.

If your requirement is to delete all the requests which are in cube, then go for DROP CUBE step. This will delete all the contents (DELTA, FULL, error DTP) of your cube.

Hope this helps!

Sheen

[RamanKorrapati]

Hi,

I think we can delete overlapping request from info cube which dtp is full load only.

So as you need we don't have option to delete error dtp overlapping request.

From PSA to info cube - is full load dtp or delta one?

Thanks

[Former Member]

Hi Ram,

PSA to DSO is Delta,DSO to CUBE is also Delta only.Whereas Monthly once.our Support team is doing full load and deleting all other request manually.

Now we are planning to do all the activity, from doing full load to deleting overlap request using Process chain.

I tried all the options in deletion selections of variant Delete overlapping request from infocube.But end up with little luck

Regards,

J.Sakthikumar

[RamanKorrapati]

Hi,

No and not possible as you need.

Why its designed like that. Daily delta load and full load monthly once(and deleting all loaded delta requests).

Possible way:

Try to implement one abap program and do the selection deletions on loaded request date based.

For example:

May 2 to May 31 ,2014 you may load delta loads. On june 1 you may load full load and will delete the old loaded delta requests. at above program you can pass you loaded dates and delete the request.for this you need to create new process chain and add above program and full load from dso to cube.This chain need to run monthly once.

Thanks

[Former Member]

Thanks Ram,

I will try with Routine.

[Former Member]

You can do one thing:

1. Create 1st process chain which has PSA to DSO and DSO to CUBE steps.
2. Create 2nd process chain which has delete contents of the cube and then the full load to Cube steps.
3. Create a 3rd process chain which will be a Meta chain which has the above 2 process chains. And in this meta chain, using decision making process type, using the formula and if else conditions, trigger the 1^st process chain on a daily basis and trigger the 2^nd process chain on a monthly basis.

Make sure, you name the process chains in a meaningful name differentiating between daily and monthly loads.

Regards,

Suchitra

[Former Member]

Hi Ram,

I tried with routine in the variant Delete overlapping request of Process chain, All the request are getting deleted, but process chain fails with short dump.

Below given are keywords
in ST22 are:"MESSAGE_TYPE_X" " "
"SAPLRSSM_PROCESS" or
"LRSSM_PROCESSU44"
"RSSM_PROCESS_REQUDEL_CUBE_PAR"

Regards,

J.sakthikumar

[Former Member]

Hi J

Are you using BW 7.31?

Just wanted to check whether you tried with below already

in deletion variant, put both DTPs (delta and full) and this deletion varaint should get trigger when you are loading full DTP (to delete all previous requests).

in deletion selection choose 'delete data requests with same DTP'

Regards,

Gaurav