My Oracle Support Banner

OBIEE 11g: Limiting the maxRows Retrieved from Essbase is Not Working in 11.1.1.9.160719 (Doc ID 2224725.1)

Last updated on JULY 18, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

Tried to set service.olap.dataQuery.grid.maxRows in essbase.properties according to <Note 2174505.1>, but the parameter is not working.

The issue reproduced with 11.1.1.9.160719.  No error returns. And more than 10000 rows returned via SmartView.

STEPS TO REPRODUCE (*)

1. Changed the property in <MIDDLEWARE_HOME>\Oracle_BI1\products\Essbase\aps\bin\essbase.properties.

Before: service.olap.dataQuery.grid.maxRows=5000
After: service.olap.dataQuery.grid.maxRows=10000

2. restart opmn related component processes, and bi_server1.

Changes

Upgraded the instance from 11.1.1.9.0 to 11.1.1.9.160719. 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.