Navigation/drilldown between BW Queries in portal

[Former Member]

Hi:

I am at a client who are using BW and Portal. They are trying to integrate a bunch of BW Queries in to Portal. Their idea is if user clicks on a query table cell value, he should be able to drilldown, and another query result should be displayed. I am able to bring the queries in to portal and show them as pages. But I am stuck how to navigate from one query display iview to another, with a click of a button or a cell content. I read about Javascript commands etc. I know about context menus. But they don't want to use context menus. It should be one click of a button since users are managers (!!!!! ?????).

Please help.

Prasad

[Former Member]

Prasad,

You have several options in meeting the customers requirements.

1. You could actually create the queries within several web templates for navigation. You can use the URL commands to switch to different queries or to drill down by creating a button. (There is a document on how to do this under the BW content of the SDN, I forget the exact name at the moment.) You can do this using the URL commands and javascript to create buttons, links or whatever they would like to see to jump from one query to another. I would probably use this in conjunction with RSBBS (RRI - Report to Report Inteface)

2. You could (if you want to have the links or jumps directly in the table results) create a user exit for the Table Class to manipulate the output to have the table class. You can look at "How To... guide on hiding a column" whitepaper on how to do this.

3. There is a whitepaper on SDN under the BW articles which discusses how to use Event Scripting in Portals to manage the jumping from one iview to another.

[Former Member]

Hi Stephen:

You have given a really good overview of various approaches for navigation. Eventhough what I want is option 2, probably I would have to go for option 1, 'cause I could not really code ABAP for the custom navigation.

Thank you so much,

Prasad