SAP Knowledge Base Article - Preview

2096858 - SQL script generated by Web Intelligence doucment is different when using Netezza Server 4 ODBC and Netezza Server 7 ODBC drivers

Symptom

  • Migrate Web Intelligence document using Netezza as data source from XI 3.1 to BI 4.0, change  ODBC driver from Netezza Server 4 ODBC to Netezza Server 7 ODBC after migrate
  • WebI report contains object using NVL() function
  • SQL script generated by Web Intelligence is different beween XI 3.1 and BI 4.0
  • Below error occurs when refreshing migrated WebI document in BI 4.0
    Error message
    Database error: ERROR: Attribute [object name] must be GROUPed or used in an aggregate function. (IES 10901)(WIS 10901)


Read more...

Environment

  • SAP BusinessObjects Enterprise 3.1 (XI 3.1)
  • SAP Business Intelligence platform 4.0 (BI 4.0)
  • Web Intelligence (WebI)
  • Netezza database

Product

SAP BusinessObjects Business Intelligence platform 4.0, feature pack 3

Keywords

BO3, change, wrong, incorrect , KBA , BI-BIP-CS , Connection Server , 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.