Automatically delete intital selection

[gergely_gombos]

Hi Gurus,

we using SAP BI 7.0

In the system, there is a customer developed AA cube. We load data to the cube every hour with delta-load info-package.

Because it is loaded every hour, there are lot of empty requests in the cube.

We would like to create a process chain (schedule in the night) which deletes all records in the infocube, and run an init-delta load.

Our problem is, we have to delete the initial selection for the init-delta data package, but we can only do this manually.

Is it possible to delete the initial selection automatically?

Any idea will be appreciate.

Best Regards,

Gergely Gombos

[mr_v · Accepted solution]

I'm using following program in process chain to delete INIT request.

REPORT ZXXX_INIT_DELETE.

Data: p_dsrce like ROOSPRMSC-OLTPSOURCE value 'DataSource Name'.

Parameters: p_logsys like t000-logsys.

CALL FUNCTION 'RSS1_QUEUE_DELETED_IN_OLTP'

EXPORTING

I_OLTPSOURCE = p_dsrce

I_LOGSYS = p_logsys

EXCEPTIONS

FAILED = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

ENDIF.

[gergely_gombos · Accepted solution]

Hi Mr. V.,

we implemented that program, tested, and it works correctly.

Thank you very much!

Best Regards,

Gergely