Hello All,
I am getting this error once in a while. I have tried all the options suggested by SAP and in forums.
Any one fixed this forever?
I am using BO 4 SP5 and Dashboard Designer.
If i increase the number of Dashboard servers in CMC does that help?
Appreciate your suggetions.
Thanks,
Arun
Arun.K 
(BOB member since 2011-10-18)
This is a very generic error that you see on the dashboards.
Please be more specific on what kind of connections you are using and any specific scenarios where you are getting this error so that some one can respond accodring to the problem.
P.S.: most of the times XLS000009 is a warning message where you do not have data in the backend.
Naveen.SAP (BOB member since 2012-11-16)
I am using a dashboard with query browser and webservices. Query browser connects to the universe and webservices to the webi report.
The dashboard is published on to launchpad as desktop and mobile version. When i open the dashboard from the launchpad i get this error, not always but some times. Initially it was a OLEDB connection which i changed to ODBC because of this issue. My database is SQL Server 2008.
When i was running with OLEDB also i was getting the same error until after many sessions the dashboard stops working.
Hope this helps.
Arun
Arun.K (BOB member since 2011-10-18)
Check if your backend has proper data to power the dashboard…
When there is no data in teh backend tables and the dashboard searches for some thing, it will throw this error.
Most of the times, even if this error is shown, the dashboard still works fine just because it is a data related issue
Naveen.SAP (BOB member since 2012-11-16)
Backend table you mean tables in the Universe? It has data and the also data is available in SQL Server 2008.
Arun
Arun.K (BOB member since 2011-10-18)
yes. The universe.
One of the reason might be, physically you can see data in the backend tables. But after you apply all the filters that you have on your dashboard, it might not be returning any data.
Have a look on it from that angle too…
Naveen.SAP (BOB member since 2012-11-16)
I have filters in the webservices (BIWS) which are not bound to any of the cells in dashboard spreadsheet.
Would that create a problem?
Arun
Arun.K (BOB member since 2011-10-18)
If they are mandatory filters, you should pass some value.
to be on a safer side even if they are not mandatory filters, bind them to an empty excel cell
Naveen.SAP (BOB member since 2012-11-16)
Ok, thanks very much. I will try and update.
Arun
Arun.K (BOB member since 2011-10-18)