Is it possible to use a Java command to RRI and then Drill Down?

[Former Member]

I am trying to build a Java command to jump from Report "A" to Report "B" through an RRI and then apply the same drill downs to report B as the user had entered in Report A. I want to use an RRI as this saves the user re-entering the selection criteria.

I can get the characteristics that have been drilled down through the command SAPBWGetDataProviderDimensions so all I need to do is complete the RRI and then reapply the same drill downs.

I've set the code to do an RRI and a simple drill down (see below) but it isn't working,it simply rebuilds the screen (IE no RRI nor expand).If I remove the EXPAND command the RRI works.

function sheptest() {

/* Get the optionnode */

myhtml = '<form name="MyShep" method="post" action="<SAP_BW_URL>">';

myhtml = myhtml + '<input type="hidden" name="DATA_PROVIDER" value="DATAPROVIDER_1">';

myhtml = myhtml + '<input type="hidden" name="CMD" value="RRI">';

myhtml = myhtml + '<input type="hidden" name="RRI_RECEIVER" value="QURY0001">';

myhtml = myhtml + '<input type="hidden" name="CMD_2" value="CMD=EXPAND&IOBJNM=0MAT_PLANT__0MATL_GROUP">';

myhtml = myhtml + '</form>';

alert(myhtml);

document.getElementById('MyForm').innerHTML = myhtml;

}

I also tried changing the dataprovider through the command RESET_DATA_PROVIDER, instead of using the RRI, but when I did this I am forced into the selection criteria screen, which the users want to avoid (as the variables are all the same).

Is what I'm trying to do possible?

Any advise will be greatly appreciated.

Cheers Shep.

[Former Member · Accepted solution]

Hi,

this is only possible with BW 3.5. There you have the possibility to add the parameter &rri=X to the RESET_DATA_PROVIDER command. This will result in transfering filters and variables to the new Query / View.

With RESET_DATA_PROVIDER you can create a command sequence.

It is not possible to have a command sequence influencing the result of the command RRI.

Heike