Symptom
- Error in universe: ''[variable name] is invalid in the SELECT list/HAVING clause, because it is not contained in an aggregate function or the GROUP BY clause.
- SQL generated contains HAVING clause instead of WHERE clause.
- Error in Increment/Decrement object assigned to the Query Filter.
- A patch was applied or changes to the PRM were made and error still occurs.
Read more...
Environment
- SAP BusinessObjects Business Intelligence Platform 4.2 Support Package 07 Patch 03
- Information Design Tool (IDT)
- Multisource universe or Single Source universe
Keywords
patch and prm changes , KBA , BI-BIP-DF , Data Federation Service , BI-BIP-IDT , Information design tool , 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.