SAP Knowledge Base Article - Preview

1380173 - SQL Button in the Query Panel of Web Intelligence 3.1 is grayed out when a combination of SQL and non-SQL (e.g. MDX or Excel) queries is used.

Symptom

  • When a Web Intelligence report has one query pointing to a non-SQL data source (example: SAP BW, Excel, CSV) and one pointing to an SQL data source (Example: Oracle), SQL button is disabled for both queries.
  • This would be correct for the OLAP data source as it is using MDX, or Excel because there is no SQL, but for the SQL data source it should be active.


Read more...

Environment

  • Business Objects Enterprise Web Intelligence XI 3.1
  • All SQL databases
  • Supported OLAP data sources: Microsoft Analysis Services, Hyperion Essbase, SAP BW
  • Personal data sources:  Excel, Text, CSV

    • Product

    SAP BusinessObjects Enterprise XI 3.1

    Keywords

    unavailable; gray; grey; greyed out; grayed out; inactive; view; unable; , KBA , BI-RA-MD , OLAP Intelligence, multidimensional databases , BI-RA-WBI , Web Intelligence , Problem

    About this page

    This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

    Search for additional results

    Visit SAP Support Portal's SAP Notes and KBA Search.