Skip to Content
author's profile photo Former Member
Former Member

Data Deletion from InfoCube

Hi,

I am loading my Infocube, a daily full load from a flatfile. Each day if the load is successful, i have to delete the previous day's load. Simple. But, it gets complicated because of the following scenario.

On some days it can happen that the flatfile contains zero records. When it happens, I do not want to delete my previous day's load. But even if the file contains zero records, the load will be successful and will not trigger an error message. So, simple controlling in the process chain might not work.

I need a mechanism that triggers an error or lets the chain know if the loaded number of records is zero. I am thinking of two options here.

1. In the start routine,

IF DATAPACKET [] is Initial.

temp = 1/0.

When datapacket doesn't contain any data, the code fails because i'm dividing by zero and the load fails, which prevents the previous request from deleting.

This is not a very good idea as there'll be a failed request in the cube, can create problems with the reports.

2. Another idea is to include an ABAP program in the process chain and check the RSREQDONE-RECORDS for the load and if it's = 0, then send an error message.

How can we return a value to the chain from the program?? Can someone help me here.

Also please comment on this and suggest any ideas.

Thanks

Gova

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2005 at 05:09 PM

    Hi Gova,

    you could raise an event from your program and then link your (sub)process chain (for deletion) to this event...

    Hope it helps !

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Gova,

      Don't know if you have tried this, but here goes:

      In the process chain, use Process <b>Delete Overlapping Requests from InfoCube</b>. In this process, click Deletion Selections and then check the last option: Request Selection through Routine. In this routine, you can access table <b>rsreqdone</b> and check the request for number of records and process accordingly.

      Hope this helps...

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.