BI Pub DataModel - Rows Dropdown in DATA Tab for xml is showing 200 as maximum in 12C but not ALL as

Question

Summary

BI Publisher xml output

Content

Hi Gurus,

We're using BI Pub version 12.2.1.3.0. When trying to export the xml for creating rtf, the ROWS dropdown is showing 200 as maximum #of rows but not ALL as in 11g. Is this something that can be adjusted?

Please let me know if there's a chance a changing this to ALL.

Thank you.

Version

12C, 12.2.1.3.0

BHANU PRAKASH CHUNDURI · Answer

Ok.

Thank you Ashish.

Ashish Shrivastava-Oracle · Answer

Yes, this is expected. This change in done due to performance reason.