Oracle Business Intelligence

Products Banner

How to increase rows return in OBIEE

Received Response
11
Views
4
Comments

HI all,

Please let me know how to increase rows return in OBIEE.

Please see the below sample code.

WHERE

((("- Plan".Plan = 'None')

ORDER BY 1, 2 ASC NULLS LAST, 3 ASC NULLS LAST

FETCH FIRST 200007 ROWS ONLY

The above logical query (part of query) returns 2 lakh records. I would like to increase this number. How to increase this?

Second question:

I have a seeded repository and i have done changes to this repository. How to find changes to the seeded repository (what are the changes done to seeded repository?)?

Regards,

Chandra.

Answers