BIWS limitations (performance issues)

[Former Member]

Couple of questions that I am hoping to clear..

1. What is the max number of connections (web services queries via BIWS) allowed in dashboards?

2. I have around 8 blocks of data (1 web service, 8 methods) that I need to import into a dashboard for desktop use only. Is this the recommended option or should I create 8 different web services for performance reasons?

3.Among 8 blocks of data, I realized that 2 of them have approx 2000 rows. I increased the excel preference to 2000 rows and then imported the methods/web service in dashboard and realized that the size of the dashboard grew to sightly more than 1MB. As I was finalizing the dashboard, it froze and excel got corrupted, hence cannot open the xlf file any more .  I am using only concatenate function (&) in excel.

I tried to retrieve xldoc.xls, but no luck

Any help will be great.

Thank you

Ann

[Former Member · Accepted solution]

Hi Ann

Limitation

You can gain simple access via the QaaWS data connection interface

Your data can easily be filtered using the filter properties in the report

You can connect to cached reports to facilitate faster response times and dashboard overall performance

You can filter, drill and prompt from your dashboard without the need to go back to the universe

It will also be available in BI 4.0 (which is what I used for these examples)

HOW TO CONNECT TO THE WEB SERVICE FROM YOUR DASHBOARD

1.  Launch SAP BusinessObjects Dashboards.

2.  Open the Data Connection Menu and add a QaaWS connection.  Paste URL into the wsdl URL box and then click Import.

3.  For this example, choose the GetReportBlock_State_Sales_Service from the Method dropdown list.

4.  In the Output Values, bind the table cell to the same number of columns as your web service report block. (Note: Choose as many rows as you think you may need)

5.  Bind the Header cell value to a single row of cells to hold your report block header.

6.  Change the usage to refresh when loaded.

7.  Preview your dashboard

http://everythingxcelsius.com/xcelsius-2008/xcelsius-and-business-intelligence-web-services-biws-par...

Regards

Nk

[Former Member]

Hi Ann,

1). What is the max number of connections (web services queries via BIWS) allowed in dashboards?

ans: Unlimited no of connections

2) I have around 8 blocks of data (1 web service, 8 methods) that I need to import into a dashboard for desktop use only. Is this the recommended option or should I create 8 different web services for performance reasons?

ans: you can use live office, if there is no calculation is required (mostly import and mapping case's)

3) Among 8 blocks of data, I realized that 2 of them have approx 2000 rows. I increased the excel preference to 2000 rows and then imported the methods/web service in dashboard and realized that the size of the dashboard grew to sightly more than 1MB. As I was finalizing the dashboard, it froze and excel got corrupted, hence cannot open the xlf file any more .  I am using only concatenate function (&) in excel.

ans: if you are using live office ,you can decrease the 2000 rows by converting it to cross tab format...

Note: Try to use live office and let us know the result...

let me know anything is required

Regards

Subbarao

[nikhil_joy2]

Hi Ann,

Fetching 2000 rows of data into the excel will surely lead to performance issue. Instead of getting all data together, perform aggregation in webi side and pass only necessary data set to dashboard. Why can't you use multiple connections and filters and drill to dataset as needed so that data fetching to dashboard at a particular point of time would be minimum. This is the best practice rather than fetching all data in excel first.

Refer below link to see a very good example of implementing BIWS with webi block and filter. As shown in example, first use a connection to fetch the prompt list and whenever a particular country is selected, fetch data for the selected country alone using another connection.

http://blog.davidg.com.au/2011/03/drill-down-in-xcelsius-using-bi.html

Regards,

Nikhil Joy

[vijaymuniraj]

Hi Ann,

This error is not with BIWS or overload in excel. You need to follow few point when you work on dashboard or exporting it to launch pad.

1. Dashboard -> files -> Preference-> Excel Options -> (Disable live office compatibility)

By doing this u can run excel even if u r exporting it( but better avoid using separate excel file when you using dashboard it creates problems in 4.0 sp5).

2. When you gets that error Go to Task manager and kill excel file that are running.

Thanks

Vijay Muniraj