APD Issue

[former_member182998]

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

[former_member186053]

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 approach.

Thanks,

Vengal.

[Former Member]

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

[Former Member]

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