SAP Knowledge Base Article - Preview

1482878 - Web Intelligence does not create SQL correctly when using Oracle Analytic Function COUNT() OVER(PARTITION BY()ORDER BY())

Symptom

  • Web Intelligence does not create SQL correctly when using COUNT()OVER(PARTITION BY()ORDERBY()) on an Oracle based Universe
  • Creating WebI report using the dimension that uses Oracle Analytic Function COUNT() OVER(PARTITION BY()ORDER BY()), SQL Query is generated wrong in InfoView
  • The following error is thrown:
    • Error:Database Error: ORA-00936: missing expression. Contact your Business Objects Administrator or database supplier for more information. (Error: WIS 10901)


Read more...

Environment

  • BusinessObjects Enterprise XIR2
  • Web Intelligence
  • Oracle Database

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

SQL, wrong, query, aggregate measure, WebI, Web Intelligence, WebIntelligence, ADAPT01444111, ADAPT1444111, ADAPT 01444111, ADAPT 1444111, 1444111, analytical, function, count, over, partition, order by, incorrect, correct, generate, create, creation , KBA , BI-RA-WBI , Web Intelligence , 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.