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?