Scheduling the deletion of a cube's data or a single request

[marco_simon2]

Hi Specialists,

I'd like to delete a single request (alternatively all data) from a cube - but by schedule.

Is that possible? I know how to to that manually in the rsa1 - but I've no idea how to schedule that activity.

Could you gimme some hints please?

Thanks in advance.

[former_member205352]

In process chain.

You have options

"Delete data target contents" and also "Deletion of overlapping requests"

[marco_simon2]

Wow - that was a rapid answer. Thanks.

Ok, two further questions:

a) Is it possible to schedule these activites programmaticaly? (without the workaround "event-triggered process-chain")

b) What is the definition of "_overlapping_ requests" ? Can I provide a Request-ID or is that generic is some way?

[former_member205352]

a) Is it possible to schedule these activites programmaticaly? (without the workaround "event-triggered process-chain")

You can just schedule the process chain and include the loading as well as deletion in the same chain.

b) What is the definition of "overlapping requests" ? Can I provide a Request-ID or is that generic is some way?

If have loaded the request for some particular condition and now want to load the cube for same condition but delete only that overlapping (same condition) request then you can use that.

Hope this helps.

[Former Member]

Hi.....

a) Is it possible to schedule these activites programmaticaly? (without the workaround "event-triggered process-chain")

If u don't want a event based chain...........Make it time based.........that on perticular days it will trigger at a particular time...........Right click on the Start process >> Change selection >> Date/time...........there give the date....when this chain will first run and the time..........Click on the Periodic button............and choose as u wish..........daily, monthly.etc......

b) What is the definition of "overlapping requests" ? Can I provide a Request-ID or is that generic is some way?

This process will delete existing requests from the InfoCube if the selection criteria of the new request partially or wholly overlap the selection criteria of the request to be deleted..........

Regards,

Debjani......

[marco_simon2]

Thanks for your (almost identical) definitions.

One futher query about that topic:

If I use the "old" data-staging-process (InfoPackage manages Data-Loading from source-system till target-InfoProvider), then the selection-criteria from the InfoPackage is relevant for the "delete overlapping requests"-feature.

If I use the "new" data-staging-process (InfoPackage loads data to PSA and DTP forwards them to the target-InfoProvider) then the filter-criteria from the DTP is the relevant one.

(Think of a case where the InfoPackage only selects data for 001.2009 but the DTP forwards all unforwarded PSA-Requests (=Delta) - without a filter. In that case I'd expect that the mentioned feature would delete all Requests from the Cube because all have been DTP'ed with "no filters").

Is that correct?