I have a webi report connected with dashboard through Qaaws/BIWS. The webi report has export values of list of countries and i need to show only a pie chart in dashboard showing the export value of country A and rest of all other countries.
So i created a variable with an if loop condition
if(country name <> A;“others”;A), pulled this into the webi report to get two records A and others. Published the report as web service and called the webservice in qaaws, linked to pie chart in the cell. But when i run the dashboard the pie chart displays only value for country A.
Is there a reason or limitation of web service to call a variable in webi?
I am using BO SP4 and dashboard designer.
I have a prompt which read country values using a combo box in xcelsius. Like you said, I inserted a grid and checked the values and find that the prompt is returning only a single country value. Its not returning other country value.
In Webi, you can preview the BI Service. Does the BI Service have both columns with data in Webi Preview ?
Did you double check your Web Service cell bindings in the Dashboard Connector panel ?
Is your prompt even working ? Is the country value changing when you switch your combo box ?
IF all of the above is yes…then continue:
Making changes to Webi blocks, does not often automatically update the BI service. If the options above fail, then delete the BI Service and publish a new one…begin your workflow again.
If all options fail above, then you are going to need a html/traffic program for your browser to see exactly what is leaving your SWF and what is coming back. I use Fiddler…a freeware program.
I removed the prompt and used direct mapping with the report.
Its now working but takes long time to refresh. The webi report has over 63 pages. Any suggestions on performance tuning for faster refresh?
If you are using the Last instance of a Published BI service, then your data transfer shouldnt even take .5 seconds. You were better off figuring out why the Prompt would not work and fixing the issue.
Direct mapping means I have removed the prompt and mapped the country value to the cell.
When I am using the prompt, I was mapping the value of the prompt to the country name in the cell, now removed the prompt from query, passed on the country value, which is mapped directly to the cell.
Yes I am using the last instance of webi, inserted 1 in getlastdocumentinstance. Isn’t that the right way?
that is right…by using getlastdocumentinstance you should be experiencing very fast response times. I am having trouble picturing what your Webi looks like, however.
The Webi’s that I use for DataSources only have 1 block in them per Report Tab… of a few rows and columns. I have never had a multipage Webi document that I use as a Datasource for BI services.
I have around 315 country names with 25 year worth of data, basically export value. I created a webi report with year, country name1 (partner country), country name2 (reporting country) and export value and set the year and reporting country as section. Then pulled the variable which makes the records into two. One record the export value of reporting country to partner country and other by rest of the world.
So for every section there will be only two records. I tried a prompt to pass the value of reporting country name to display, but doesn’t work.
Like you said, how can I make this webi report smaller I mean to a single page instead of multipage.
The passing of the Country prompt is the key. This can and should be working. In your case there is a problem with the set up. I dont know what the issue is… Probably syntax. Remember that all values, prompt names, and syntax is Case Sensititve.
But, if you cannot get the prompt variable going…
You cannot have Sections or Groups in a block using BI service…Sections is going to mess everything up.
Get rid of the sections so that you have One Block of rows and columns.
I tried the prompt again and it did not work. Just want to make sure that we are talking the same thing, by prompt I mean the filter I put on the report query. I removed all the sections and made a single block of webi but did not see any significant difference in run time.
what is the name of the filter in your webi query?
is it called Country or country ?
the the name of the filter above referenced in your QaaWS in Dashboard Design ?
In the InputValues panel for the web service where the name of the filter is referenced, do you have the Input to the correct cell? and What is the value for the Operator Property ?
I think I am close to finding the problem. While testing BIWS in webi, if I put Refresh = True I get the correct country value. If I remove Refresh = True the value defaults to the prompt country.
In dashboard I am getting always the default value irrespective of which ever country I select. That means the webi report is not getting refreshed even after passing Refresh = True from Qaaws
(BOB member since 2011-10-18)
