RRI Jump to BW query in a different system

[Former Member]

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.

Cheers,

Thomas.

[former_member185071]

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.

Cheers

K M R

[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?

Thanks,

Thomas

[cornelia_lezoch]

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

Cornelia

[Former Member]

Hi Cornelia,

Many thanks for your input.

To add, the requirement is to show the jump result in Analysis Office, so not in a browser. Any idea on how to achieve this?

Thanks,

Thomas

[cornelia_lezoch]

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...

regards

Cornelia