How to increase rows return in OBIEE

Question

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.

[Deleted User] · Answer

3319067 wroteI want to understand that is it based on data model in BMM layer, the record limit will be set.

No it isn't. It's presentation server settings. Read the documentation

Thomas Dodds · Answer

200k+ rows in an analytical tool - leads me to believe the tool isn't being used for its intent or design....

It's a system configuration item - easily found in the documentation.

User_JL3CW · Answer

Hi,

I want to understand that is it based on data model in BMM layer, the record limit will be set.

Regards,

Chandra.