Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Value for ROWNUM in generated SQL doesn't match configuration.

The physical SQL generated by BI Analysis queries ends with 'order by c2, c3 ) D1 where rownum <= 300001', however, this value doesn't match our configured settings.
Our configuration settings are:
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<ResultRowLimit>250000</ResultRowLimit>
<DefaultRowsDisplayed>30</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>250000</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>250000</DefaultRowsDisplayedInDownload>
Our Repository settings for all User/Application Role Permissions are:
Status Max Rows = Ignore and Max Rows=100000
Where else could the value for rownum be coming from? We are running OBIEE 11.1.1.9.0.
Thank you.