Controlling Query Result Set Size

Query governors vary for relational access methods.

Custom document SQL spreadsheets and relational drill-through methods enable users to declare query governors as they create SQL queries or relational drill-through definitions.

When you drill from OLAP to relational data, passing only the drilled OLAP member to the relational data source may result in a large query result set. To focus and diminish query result sets, users can pass page and filter dimensions specified in the OLAP documents.

Other relational access methods rely on the Analysis.properties file to limit query result sets.