If your OBIEE server has reports/tables with a large dataset and fetching such large number of records from OBIEE into Tableau or Power BI or Qlik causes overload to your server, there are 2 ways to limit the number of records to fetch using BI Connector.
- User query limits
- OBIEE query limits
User Query Limits
Every user can increase/decrease their query limits based on the number of records to work with or faster retrieval of data with minimal records.
To make these changes refer to the steps in this article.
OBIEE Query Limits
Besides the User query limits,OBIEE Admin can define their limits based on the configuration and performance of the OBIEE Server. This take higher precedence than User Query Limits.
OBIEE Admin has to set the session variables and their value in OBIEE Server in the same name as below:
BIC_LIMIT_MAX_ROWS_PER_QUERY
BIC_LIMIT_TOTAL_RECORDS_PER_REPORT
Note: If both user query limit (BI Connector) and OBIEE query limit (OBIEE) is set as proposed above the values are compared internally and the minimum value is chosen.