Skip to Content

Hi Community,

this is my first blog post that is created because of this question: http://scn.sap.com/message/14125897

The Question in an overview should be: Is it possible to jump from a dashboard to another report with filtering it directly? – Yes it is and I will explain in a short post how you can solve this requirement. I will explain it only for a dashboard that filters something to jump to a web intelligence report but it is also possible to jump to a dashboard, a crystal report or a design studio application or something else.

What you need:

You should know how opendocument hyperlinks work (http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_opendocument_en.pdf)

Step-by-step:

1. Create a dashboard with the components you need. Create also a webi report because you need the opendocument link for that report in your dashboard.

2. Insert your filtering components like dropdowns or checkboxes for example (screenshot 01)

Snap_2013.06.17_15h51m34s_005.png

screenshot 01: Dashboard example with two filter components that are linked to Excel cells.

3. Insert the Base-URL to your second report you want to jump in an Excel cell (screenshot 02). For example:

http://bo-server.domain.lan:6405/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AUirUrUJMMNOnd0sK_kCdrI

Snap_2013.06.17_16h13m45s_008.png

Screenshot 02: Insert Base URL to an excel cell

4. Underneath you can concatenate all informations you need with Excel functions (screenshot 03). For example:

=B9&”&filter1=”&B3&”&filter2=”&B5

Snap_2013.06.17_15h13m54s_004.png

Screenshot 03: Concatenate all cells you need to create the URL with filter values.

Legend:

B9 = base-URL to webi report (step 3)

filter1 = name of the parameter you want to pass to the webi report

B3 = in this example the destination of the selected value in the dropdown

filter2 = name of the second parameter you want to pass to the webi report

B5 = in this example the destination of the checkbox (value for checked or unchecked)

5. Create an URL-Button and link the URL property to your concatenated URL (screenshot 04)

Snap_2013.06.17_16h00m51s_007.png

Screenshot 04: Insert URL Button with link to your URL cell in Excel

6. Save the dashboard to your BI Platform and open it for example in your BI Launch Pad or via opendocument link. You can now filter your values with the dropdown and the checkbox and these values will pass to your webi report if you click on the URL Button.

I hope this short guide can help you to use a dashboard-to-other-report interface. How you use the opendocument link to pass parameters to your bex query inside the webi is described in other blogs or in the opendocument guide.

Best Regards,

Benni

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

      1. mina bhatt

        Hi benjamin,

        I want to link a dashboard to my webi report using document linking which can pass the same parameters which i have selected in y webi report.. could you please help me with that

        like when my users click on the hyperlink from webi report a dashboard report opens and gives the same prompt values which they have slected in webi??

        please help

        (0) 
          1. John Barrero

            Hi Benjamin,

            Is it possible the jumping to an ECC transaction from Dashboards? For instance, I have a dashboard with a table and by double-clicking on one row the ECC transaction is displayed.

            The dashboard is stand alone and runs on one application called MII.

            I appreciate your comments.

            Thanks,

            John

            (0) 

Leave a Reply