Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Delete Request using a Routine in the Scheduler

Hi all,

I have an infocube. Data are loaded into this cube on a <b>weekly basis</b> according to the following requirements.

Example:

Let's assume <b>we are in April</b>and <b>April has 4 weeks</b>:

<b>Week 1 of April</b> - Data for week 1 are loaded

<b>Week 2 of April</b> - Data for week 1 and 2 are loaded

(request for week 1 is deleted)

<b>Week 3 of April</b> - Data for week 1, 2 and 3 are loaded

(request for week 2 is deleted which were the data for week 1 and 2)

On the <b>2nd day of the following Month (in our example this would be May 2nd) Data for week 1, 2, 3, and 4 of April are loaded.</b>(request for week 3 is deleted which were the data for week 1, 2 and 3).

<b>These April data</b> (loaded on the second day of the following month) <b>should stay in the cube then and not be deleted any more.</b>

The procedure for the following Months (i.e. for May etc) should be the same.

This means

<b>Week 1 of May</b> - Data for week 1 are loaded

<b>Week 2 of May</b> - Data for week 1 and 2 are loaded

(request for week 1 is deleted)

etc.

On the <b>2nd day of the following Month (in our example this would be June 2nd) Data for week 1, 2, 3, and 4 of May are loaded.</b>(request for week 3 is deleted which were the data for week 1, 2 and 3).

<b>These May data</b> (loaded on the second day of the following month) <b>should stay in the cube then and not be deleted any more.</b>

CAN ANYBODY HELP ME WITH THIS REQUIREMENT AND TELL ME HOW I CAN DO THAT?

CAN I DO THAT USING A ROUTINE IN THE SCHEDULER ON TAB DATA TARGETS TO DELETE THE REQUEST BASED ON THE LOGIC DESCRIBED ABOVE? DOES ANYONE HAVE SAMPLE CODE FOR THAT?

Former Member
Not what you were looking for? View more on this topic or Ask a question