Skip to Content

APD Issue

Hello All,

I have a APD running once in a month which is trying to fetch the data from a Info cube via a Query .

But many a times, it happens that , when APD is triggered, the Source Infocube is in process or is in execution of Data load,

due to which my APD returns zero records as a result . And this leads to in correct reports.

Here can you please suggest, how can I make my APD wait till the data load in the Source Infocube is completed.

Once the data load in Source Info Cube is completed, system can asume that the APD is OK to execute.

Note : In PC there are many other variants and APD's as well, the APD in concern is not positioned just after start variant.

Any help in this regards will be appreciated .

Regards

YN

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2016 at 03:51 PM

    Hi,

    as a quickly answer.

    Move the APD to last step in your PC.

    or

    Create a Meta Chain with the actual PC and a new one with only your APD and connect them.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2016 at 04:28 PM

    Hi,

    Is Execution of DTP for source Info cube is not variant of Process chain which includes APD Execution?

    If you want to check Data load in Info cube before Execution of APD then you can add ABAP program variant to do this before APD Execution variant in Process chain.

    You can write like this:

    DATA: l_rsbkrequest TYPE TABLE OF rsbkrequest,

    linestransferred TYPE SYTABIX,

    v_dtp TYPE SY-SUBRC.

    select SINGLE DTP FROM rsbkdtp INTO v_dtp WHERE OBJVERS ='A' AND UPDMODE= 'D' AND TGT = 'Infocube name'.

    select LINESTRANFERRED FROM RSBKREQUEST as t INTO (linestransferred) WHERE DTP = v_dtp and not exists (select * from rsbkrequest where DTP = v_dtp and requid > t~requid ).

    While(linestransferred <> 0).

    WAIT UP TO 30 SECONDS.

    ENDWHILE.

    add this program as process chain variant.

    Thanks,

    Mukta

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 12, 2016 at 08:28 AM

    Hi Yogesh,

    If you know the average time to complete the PC of cube load daily , based on that you can schedule your APD PC to run after cube load(PC).

    Or

    If you are using third party monitoring tool, you can make the APD PC as dependant on Cube PC.

    Or better you can also go with Former Member approach.

    Thanks,

    Vengal.

    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.