SAP Knowledge Base Article - Preview

1181471 - SQL syntax in query shows that grouping is not occurring on the server

Symptom

The SQL syntax in a query generated by BusinessObjects shows that grouping is not occurring on the server.
For example:
SELECT "A", dbo.mytable.myid, sum(mydata)
  FROM mytable
  GROUP BY dbo.mytable.myid


Read more...

Environment

  • Windows 2003 Server
  • Microsoft SQL Server 2000
    or
  • Microsoft SQL Server 2005

Product

SAP BusinessObjects Business Intelligence platform 5.1.8 ; SAP BusinessObjects Business Intelligence platform 5.1.9 ; SAP BusinessObjects Business Intelligence platform 6.1.3 ; SAP BusinessObjects Business Intelligence platform 6.5 ; SAP BusinessObjects Business Intelligence platform 6.5.3 ; SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

WITHOUT CONSTANT PRM GROUPBY WITH OUT , 113072 , KBA , BI-RA , Reporting, analysis, and dashboards , 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.