Automatically delete intital selection
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.
Mr. V replied
I'm using following program in process chain to delete INIT request.
Data: p_dsrce like ROOSPRMSC-OLTPSOURCE value 'DataSource Name'.
Parameters: p_logsys like t000-logsys.
CALL FUNCTION 'RSS1_QUEUE_DELETED_IN_OLTP'
I_OLTPSOURCE = p_dsrce
I_LOGSYS = p_logsys
FAILED = 1
OTHERS = 2.
IF SY-SUBRC <> 0.