Symptom
- A Web Intelligence report returns only 500 rows with a Hana OLAP connection
- The same MDX query run in Hana Studio returns 10,000 rows
- The Hana logs show:
- # ResultSet:: there are more rows(Accumulated Row Count:7000)
- Web Intelligence logs show:
- SapSqldbcConnection::createStatement() -> Setting FetchSize=7000
- C3_RefreshInfo:PartialRefresh...(rows:500)
Read more...
Environment
- SAP BusinessObjects Business Intelligence Platform 4.2
- SAP BusinessObjects Business Intelligence Platform 4.3
- Web Intelligence (WebI)
- Hana database
- OLAP connection
- MDX
Product
SAP BusinessObjects Business Intelligence platform all versions
Keywords
KBA , BI-RA-WBI , Web Intelligence , 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.