overlapping Request Deletion from cube through process chain

[Former Member]

          Hi All,

          I want to delete the request from the cube which loaded on that day through process chain.

          Data loading to cube everyday night at 12:30 AM through process chain. I want to re run the process chain at 5 AM. for this i want to delete only

          the latest request loaded in to the cube through process chain.

          For example:

                              on 03/12/2015 at 12:30 AM data loaded in to cube through process chain. after i will rerun the process  chain at 5 AM at that time

                              process chain should delete that overlapping request which loaded at 12:30 AM.

          There are different overlapping request deletion options are there, but those are not satisfy my requirement. i want to delete only the current day               overlapping request. this can be possible only through routine or is there any other way.

          if it is possible through routine please guide me how to write code.

          Regards,

          Srimanth.

[Former Member]

HI,

Sorry for the late reply.

will please guide me how to write routine for delete the latest request from the cube.

Regards,

Srimanth.

[RafkeMagic]

How about selecting the following:

v Only Delete Requests from Same DTP

Selections Are

* Same or More Comprehensive

that should do the trick, right?

Unless you load using 2 different DTPs... but that's not clear from your post.

PS you can even use

V Request Date

* Is Yesterday or Today

[Former Member]

Dear Boudewijns,

i want to delete only today latest request i don't want to delete other old requests.

from 3 different DSO data is loading to the cube that to full update.

Thanks,

Srimanth

[Former Member]

Hi Srimanth

since you want to delete the last request which was loaded at 12:30 AM thn you can use

'Delete request from same dtp' and mention 0 days old request.

it should do the trick.

Regards,

Gaurav

[Former Member]

Dear Gaurav,

Tell me one thing it will not delete old request right?

Because if it delete's old requests i cannot get the data back. in development i doesnot  have any old request data.

Regards,

Srimanth.

[Former Member]

Hi Srimanth

No it won't delete old (yesterdays') request.

Also as per the design u mentioned u r deleting data frm cube, in DSOs data would b available if you want to load again.

/Gaurav

[RafkeMagic]

in that case I would go with a routine... I don't see the option to mention "0 days" old request as mentionned by Gaurav Sanchora (we're on BW7.3 SP7)

[Former Member]

Dear Gaurav,

In the underline targets i have 2 DSO are direct update DSO

In the Direct update DSO wont hold the data in request form. how can i repull the data.

Regards,

Srimanthu.

[former_member220624]

Hi,

Can you explain the data flow.

Ideally if you have a info-package-PSA-DTP-Cube flow with DTP setting as delta you need not worry about deleting overlapping request.

Regards,

Amit

[Former Member]

Hi Amit,

cube is getting data from 3 different DSO'S all are full update.

2 DSO'S are updating  through APD'S  which are created on Multiprovider.

one DSO Data is getting from 10 diffrent data sources. all requests are full updates only.

Regards,

Srimanth.

[RamanKorrapati]

Hi Sri,

Can you change data deletion before run your today load.

mean today you can run load at 12.30AM.

Tomorrow you can run load at 12.30AM and  delete yesterday loaded request.

Thanks

[Former Member]

Hi Raman,

As per my requirement i have to run twice in the morning.

12:30 run will fetch the Yesterday postings only.

User want to see up to 5 AM whatever postings entered in system.

use can ask one question everything is full update why cannot we delete entire data and load all data again.

in the transformation we kept formula as cal.day as system date.

and few flat file data loadings are also there which data is changing daily or 3 days once.

Regards,

Srimanth.

[RamanKorrapati]

Hi sri,

Have you tried Raf suggestion?

Lets try and lets know the result.

Use below conditions to delete overlapping request which comes from your data source.

Deleting existing request.

Data sources are same

Selection - overlapping

Request date - Yester day or today.

Here you can create two process chains.

1. Create first chain all data load process type steps without deleting overlapping request process type and trigger at 12.30 AM on daily basis.

2. Create 2nd chain which all loading process type and add delete overlapping request(from cube by using above selections) process type and trigger at 5.00AM on daily basis.

Thanks

[Former Member]

Dear Ram,

I have one doubt. if i select deltion type is "Yesterday or Today".

suppose in my cube i have yesterday request and today 12:00 AM Request. if i run process chain at 5 AM which request it delete today only or yesterday and today both.

Thanks,

Srimanth.

[RamanKorrapati]

Hi Sri,

Lets do the test at dev system and will know the result.

But if your deleting  overlap request at 5:00AM on daily basis then how can we except Yester day request at cube level?

Even if we have yesterday request then your report leads duplication.

Thanks