SAP Knowledge Base Article - Preview

1416553 - Desktop Intelligence and Web Intelligence generate different SQL

Symptom

  • Web Intelligence report performance worse than Desktop Intelligence report  base on same Universe.
  • Desktop Intelligence and Web Intelligence generate different SQL do same query use same Universe.
  • The Desktop Intelligence report can generate SQL with filters in the FROM clause.But the same query in Web Intelligence report can not generate SQL with filters in the FROM clause. It will put the filter into WHERE clause.


Read more...

Environment

  • Operating System: Windows 2003
  • BusinessObjects Enterprise  XI 3.1 Fix Pack 1.1

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

BusinessObject Enterprise XI3.1,ANSI92,Desktop Intelligence ,Web Intelligence,different SQL , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Bug Filed

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.