SAP Knowledge Base Article - Preview

3675577 - How to use the “HLL_Count_Merge” function of BigQuery within the BusinessObjects Universe.

Symptom

When using the “HLL_Count_Merge” function specified in the SQL definition of a measure in the UNX universe, an error occurs during report refresh. 
Error message is:

>> The following Database error: "[Simba][BigQuery] (70) Invalid query: SELECT list expression references Table__12.usage_date which is neither grouped nor aggregated at [2:3]."


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.3
  • Web Intelligence
  • Information Design tool
  • Google BigQuery

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

Bigquery, HLL_Count_Merge, WEBI, IDT, UNX , KBA , BI-BIP-IDT-DFX , Data Foundation Layer , BI-RA-WBI , Web Intelligence , BI-BIP-SL , Semantic Layer , 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.