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

Delete overlapping requests of same DTP from cube

Dear All,

i want to delete over lapping requests of same DTP in cube, but here while i am searching for the DTP in process variant, the system is not showing the DTP(it is active).

can you people have any suggestions.

Br,

Vamshi.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2014 at 11:28 AM

    Hey Vamshi,

    Is your DTP a full one or delta one ? Delete Overlapping reqs is not possible for Delta loads.

    In Load Process and Post-Processing option you will find Delete Overlapping Requests from InfoCube, drag and drop and make the following settings:

    Object Type = DTP

    Object Name : DTP Name.

    Check Edit all InfoCubes with the following Delete Selections and click on Delection Selection

    Check Delete Existing Request and check Only Delete Req from same DTP

    Activate and execute the PC.

    Hope this helps!

    Sheen

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      yes, you cannot delete overlapping requests for DELTA DTPs as delta essentially means NEW data which has to come from the last time the pointer was set.

      While overlapping requests means that the requests which have same data (which is the opposite of DELTA). You will note that DELETING OVERLAPPING reqs is only for cubes for corruption of data (this can happen only in full loads due to additive nature of cubes as DSOs inherently overwrite).

      You wont need to do a overlapping req deletion for a DELTA DTP.

      Hope this helps!

      Sheen

  • Posted on Jun 03, 2014 at 10:38 AM

    Hi,

    While defining selections for that process, you need to choose DTP as object type.

    Thanks


    dtp.jpg (39.6 kB)
    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.