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

overlapping Request Deletion from cube through process chain

Hi All,

I want to delete the request from the cube which loaded on that day through process chain.

Data loading to cube everyday night at 12:30 AM through process chain. I want to re run the process chain at 5 AM. for this i want to delete only

the latest request loaded in to the cube through process chain.

For example:

on 03/12/2015 at 12:30 AM data loaded in to cube through process chain. after i will rerun the process chain at 5 AM at that time

process chain should delete that overlapping request which loaded at 12:30 AM.

There are different overlapping request deletion options are there, but those are not satisfy my requirement. i want to delete only the current day overlapping request. this can be possible only through routine or is there any other way.

if it is possible through routine please guide me how to write code.

Regards,

Srimanth.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Dec 03, 2015 at 06:35 AM

    Hi,

    Can you explain the data flow.

    Ideally if you have a info-package-PSA-DTP-Cube flow with DTP setting as delta you need not worry about deleting overlapping request.

    Regards,

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2015 at 08:20 AM

    How about selecting the following:

    v Only Delete Requests from Same DTP

    Selections Are

    * Same or More Comprehensive

    that should do the trick, right?

    Unless you load using 2 different DTPs... but that's not clear from your post.

    PS you can even use

    V Request Date

    * Is Yesterday or Today

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2015 at 10:59 AM

    HI,

    Sorry for the late reply.

    will please guide me how to write routine for delete the latest request from the cube.

    Regards,

    Srimanth.

    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.