BI Webservices are not working Consistently in the dasahbord

[former_member195446]

Hi Experts,

i have cretaed dashabord with BI webservices(webi blocks as source).i have cretaed multiple blocks and applied set filters at time of publsihing to BI webservices.i have used those webservices into Dashabord,im not getting any error but the dashabord behaviour is inconsistent.

to get more idea about this isseu,please see the example:

im passing the input values from dashabords are suppose:Region=A,Location=USA,State="ALASKA",the dashabord populating correct values with these filters but some times the data get wrong and showing total data(means its not taking any filters,so i was getting total data in dashaboard).

Note:im not using any prompts(query level filter in webi).im using only report filters.

Thanks,

Prasad

[former_member194862]

Hi Prasad,

There is a known issue with the BIWS on BI 4.1 SP4 where the queries fail when we trigger multiple BIWS at the same time.

You can upgrade to BI 4.1 SP5 Patch 3 which has a lot of issues with the BIWSes resolved.

You can find further details on the issues with te BIWS in the SAP note 2114577 - Dashboard is randomly not complete when consuming multiple different "Document As A Web Service" web services.

Regards,

Amit

[vijaymuniraj]

Hi,

Its may happen due to mapping more than one sources to same destination. for example if two sources are mapped to same destination, the data will be overlapped and displays wrong data(first time it will display correct one but if you filter tat will lead to overlapping).

Once again try to remap all the filter components.

Make sure u did not miss any filter component that works on background.

or

Try to create a new dashboard with one or two blocks and see if data is populating correctly.

Thanls

[Former Member]

Hi Prasad,

Check the behavior using connection refresh button.

[former_member195446]

HI Abhilasa,

my queries are firing successfully but its pulling some times correct data and sometimes not.

Thanks,

Prasad

[Former Member]

Hi Prasad,

Map a label component to the cell that contains the value for the prompt.
Refresh the query (maybe by selecting the value for the prompt) and see if correct value is passed.
Which means check if the correct value is seen in the label component.