Skip to Content
author's profile photo Former Member
Former Member

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

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>';


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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2004 at 04:52 PM


    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.


    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.