Click a KPI result link to pop up a new window to show all the doc records related to this KPI

[Former Member]

hi All,

The business requirement of our customer is to show a KPI at the top and all the service documents related to this KPI at the bottom of the same page.  But you know that BO Dashboard is not suitable to show many records in a page that we would like to just show this KPI result as a link (through a URL component) and then ask the user to double click the link to pop up a new window to show a BW WAD or Query result of many records.  Our question here is how to construct the link with parameter(input variable) transferred in?   Before running this KPI, user will input a Year.Month, e.g., 2013.06, then the KPI calculated result of all this month comes up from a BW query as a link, then user double click this link would pop up a new window to transfer this user input value of 2013.06 to run a BW WAD or Query. 

Any valuable idea on how to construct such link by transferring the input variable is greatly appreciated and rewarded with points here!

Kevin

[Former Member · Accepted solution]

Hi Kevin,

Make KPI ---As selector ,Use Spreadsheet table for each KPI.So that Data can be seen below Snapshot.Use Behavior Option to hide/show for each KPI.

[Former Member]

Hi Kevin,

If you are using Dashboard designer to design the dashboard, there is a URL component using which one can call any URL.

Now, the URL you are expecting is SAP BW WAD application not SAP BO. In BO platform if u r creating webi using bw query, then one can use opendocument url and pass the argument as mentioned below.

Sample:

http://<server name>:port/OpenDocument/opendoc/openDocument.jsp?styp=wid&iDocID=<CUID of Webi>&sRefresh=Y&lsS<ParameterName>=2013.06

You should look for a url processed by SAP BW or WAD application, suggest you to post on correct section

Regards,

Rama

[alexandre_dussac]

Hi Kevin,

Do you know the BI_COMMAND?

http://help.sap.com/saphelp_nw70/helpdata/en/43/ef05462480025ae10000000a1553f7/content.htm

This I think can help you achieve your business requirements.

You should build this URL in the Excel of your dashboards dynamically to retrieve the LOV you want to pass and then link your URL button to this dynamic cell.

Alex