Using Webservice in Dashboard

[Former Member]

Hi SCN,

I need to create a Dashboard based on webi report through Webservice option.

1. Please let me know how to create the same.

2. How to limit the data set in Webi and performance tuning so as not to get more data into Dashboard.

3. Any performance tuning methods .

4. How to pass prompt values from Dashboard to Webi.

5. Any best practices.

Regards,

Nagaraj

[vinay_mhaske · Accepted solution]

Hi Nagaraj,

Here are the step by articles on how to create Xcelsius Dashboard on BIWS and how to pass prompt to BIWS:

• How to create Xcelsius Dashboard based of BI Web Service ( BIWS )

      http://scn.sap.com/docs/DOC-29765

• How to pass parameters to BI Web Service (BIWS) from Xcelsius

      http://scn.sap.com/docs/DOC-30356

For best practices you can refer following article:

http://wiki.sdn.sap.com/wiki/display/BOBJ/Dashboards+(Xcelsius)+General+Best+Practices

Hope this helps!

Regards,

Vinay Mhaske

[Former Member · Accepted solution]

Hi Vinay,

Thanls for the inputs.

I am trying to pass values from Dashboard to Webservice , I am not able to see refereshed data.

Do I need to set any parameters in Data connection ?

Regards,

Nagaraj

[vinay_mhaske · Accepted solution]

Hi Nagaraj,

Step 26 in the below article should help you with this:

http://scn.sap.com/docs/DOC-30356

Regards,

Vinay Mhaske

[Former Member]

Hi Nagaraj,

As suggested by Vinay, you can have a better understanding if you go through the docs.

The key concepts here are Performance and Restricting data at Webi level by passing prompt values from Dashboard.

This needs a separate web service URL with a List of values (Object placed in prompt) from Webi to avoid sending hard coded values from Dashboard.

Map those values/Web service Query data to a selector, as shown in the below.

Select the Query data option, it will pop up with Data Manager Wizard with list of connections available. select the desired connection and select the object.

Now no need to map static values values from Spreadsheet to component....

Hope this is add-on to the above post...

Thanks,

Raju

[former_member184839]

Hi Nagaraj,

Check out these Threads, these d give the reply to your queries.

http://scn.sap.com/thread/3217614
http://everythingxcelsius.com/xcelsius-training/xcelsius-and-business-intelligence-web-services-biws...

http://scn.sap.com/thread/3182564

Hope this helps.

Thanks,

Sara