Qlik Community

QlikView Connectors


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

OLAP Connector: Automatic filtering when including new fields


We are using OLAP Connector to retrieve data from SAP BW.

We recently found that there are specific fields that are limiting the number of registers. For example, we were extracting 500 rows and there should be 5.000 for that specific query.

We finally discovered that, only commenting one field (and therefore excluding it from the extraction) the number of records was correct. Actually, these 500 records of the beginning were the ones that did not have values for this field.

This is not happening only in one query and neither for one info provider only.

How can it be that just the inclusion of fields affects the number of records?

Thank you in advance.