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

Filtering from ODS to InfoCube

Dear All,

is it possible (and how) to apply filters in the data flow from ODS to InfoCube.

What I mean is: is it possible not to load in the I.C. certain rows according to some conditions?

Thanks a lot,

R.C.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2005 at 01:23 PM

    I would imagine the best place for this is the Start Routine in the update rules from the ODS to the cube.

    I usually add the following ABAP:

    delete from data_package where <something> = <something>

    This will remove any data before the update rules are processed and is usually the most efficient way.

    alan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2005 at 01:24 PM

    Hi,

    I can think of two ways in which you can restrict your data loads.

    1. You can do that by implementing a start routine in the update rules that feed data from ODS to Infocube.

    You have access to the whole data package in the start routine. There depending on some condition you can exclude certain records by writting a abap routine.

    2. If your condition is simple then you can even write a simple routine in the update rule, where depending on the option make the RETURNCODE field not equal to 0. This will help you to skip the record from getting updated to the data target.

    Hope this helps you. If not, then can you please explain your scenario, so that we can come up with some solutions.

    Thanks

    Prashant

    Message was edited by: Prashant Singh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Both your answers are really clear, thanks.

      I am quite at the beginning so I must understand better how to write routines.

      But I have quite good skills in programming so I think it won't take so long :).

      Thanks.

      Regards,

      R.C.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2005 at 06:57 AM

    HI,

    You don't need to know the infopackage name for writing the routine. Whenver you would execute any load to the data target, the start routine will execute. So just write the condition based on which you will delete the records from the datapackage.

    Hope it helps. Please asign some points if our answers really helped you.

    Thanks

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2005 at 06:49 PM

    Hello Roberto,

    this HowTo paper could give you additional help to understand how it works.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to aggregate data in the update rules for performance.pdf

    Kind reg.

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

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.