Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Value for ROWNUM in generated SQL doesn't match configuration.

Question
1
Views
0
Comments
User_XPXTC
User_XPXTC Rank 1 - Community Starter

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.