Is is possible to pass query parameters to SAP BOE Dashboard through URL?

[Former Member]

I have used Open document API for accessing Crystal reports through URL.

We can pass certain query parameter values appended in the URL and the report query filters the data accordingly.

Is it possible to to something similar in a dashboard?

For e.g. I have 750 dealers but I need to have a single dashboard for all where in I can pass the dealer code to the dashboard and then the dashboard displays the filtered data on it.

[former_member184839]

Hi Prachi,

Look into this thread.
http://scn.sap.com/thread/1650414

Thanks,

Sara

[vinay_mhaske]

Hi Prachi,

Yes. For this you will have to use Flash Variable connection.

Here are the steps:

1.    Create new dashboard in Xcelsius and go to Data Manager.

2.    Add a Flash Variable connection. Let’s say name of Flash Variable is Value1

3.    Now map Value1 Flash Variable with excel cell. Let’s say cell A1.

4.    Publish this dashboard to the SAP BO Server.

5.    For passing value to the dashboard Flash Variable refer following url:

http://<server name:portnumber>/OpenDocument/opendoc/openDocument.jsp?iDocID=<CUID of the Xcelsius dashboard swf file to be opened>&sIDType=CUID&Value1=1001

Note: 1001 is the value passed to the Flash Variable Value1 which will be copied to the excel cell A1.

Hope this helps!

Regards,

Vinay Mhaske

[Former Member]

Hi Vinay,

1.I added a new Flash variable connection and named it value1

2.Kept the variable format as CSV

3.In Variable data added a range and linked it to Cell A1

4.Added a grid with source data as range A1 to  A2 (A2 contained some random text)

5. Saved this dashboard on repository and took its open document link from the BI launch pad.

6.Appended the value1 parameter as follows.

http://WINDOWS-CRYSTAL:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AUuyAQx9WU...

7. what i expected was the grid to show up with 1001 and the random text but i was bale to see just the text.

Please let me know if i have missed something.

Regards,

Prachi Kane.

[fabio_pinho]

I was having the same issue, but solved by doing the following:

1. Added a new Flash variable connection and named it "Variables"

2. Changed the variable format to XML

3. In Variable data added a range name "Var1" and linked it to Cell A1

4. The URL to this variable that worked is as follow:

http://localhost:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=ATn78MitEiVLh55J...

In the URL you have to use the Range Name (in my case: Var1) and you have to put a lsS before the range name.

Hope it works this time.

[Former Member]

Thank you Fabio, It worked !!