In OBIEE 11g maximum number of records to be shown in a reports can be restricted from enterprise manager(em) click here for details, However if someone needs to overwrite the maximum number of records in a report then it can be achieved by adding
"FETCH FIRST 50000 ROWS ONLY" in the Prefix section Under "Advanced' tab of analysis and Click on "Apply SQL"
*50000 being the custom value, as per the requirement.
No comments:
Post a Comment