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

RRI Jump to BW query in a different system

Hi Everyone,

I'm currently looking for a solution for the following scenario in a BW 7.4 environment (trawling SDN haven't bring me much luck):

I have 2 BW systems (let's call them A and B). In system A, I have "Query 1 - summary", in system B, I have "Query 2 - detail". The requirement is for me to do a drill down from "Query 1" to "Query 2".

To achieve this, I'm looking at the RRI method provided by BW and am attempting to configure a jump. However I can't seem to achieve this, even though the options seem to be there.

It looks like BW is treating this jump similar to a jump to ECC when I configure it with the below setup (chosen Source System and selected the targeted BW system (System B), selected BW query as the report type, in the report, inputted the BW query name, left the assignment details as-is).

It also required me to input an infosource, else the jump wizard will pop up when I tried to perform the jump, furthermore the jump will fail (as I think no infosource should be necessary - CMIIW).

Note that "Query 1" is built on top of a multiprovider (with multiple cubes below it).

Would like to avoid building a multiprovider or pulling the data to the sending system, as this will amount to duplication.

Many thanks in advance for the valuable inputs, any pointer is highly appreciated.



rsbbs.png (26.0 kB)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Feb 06, 2017 at 04:23 PM

    Hi Thomas,

    I think you can only jump to a web adress in the other BW system.

    So generate the Query URL and use this one as the jump target.

    best regards


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Thomas,

      I have not worked that much with AfO yet. So I am not sure, if it is possible to connect 2 different BI systems to the same AfO installation and have them both open at the same time. (I am assuming that the jump source is also AfO).

      When AfO is included, it might be better to implement your own VBA code instead of RRI jump...



  • Posted on Feb 06, 2017 at 04:47 PM

    Hi Thomas

    It is not necessary to create a transformation/info source while you are doing the assignment ensure that your common characters are mapped.

    Between your source and target queries . If there are no common Characteristics or filters then you need an infosurce /transformation to pass the parameters and match the output values.


    K M R

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi KMR,

      Thanks for your input.

      The jump attempts to run a query in another system, hence why I've put the target system as source system.

      I know for local, that you don't need to create transformation/infosource, however when I selected another system as the target, it requires me to create them.

      Do you have an example on a successful jump to another SAP system?