How to increase rows return in OBIEE

User_JL3CW

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.

Christian Berg-0racle

a) OBIEE works with models. Not SQL queries.

b) What is a "seeded repository" supposed to be? OBIA?

c) This is an english speaking forum...so base 10 mathematics please.

d) You know there is a function to search the forums and google exist as well? Because:

e) Your question is being asked at least once per month

f) Documentation is great if one reads it: https://docs.oracle.com/middleware/12213/biee/BIESG/GUID-FF6954BA-2DE0-4422-BA58-05F32936F4FF.htm#BIESG3262

User_JL3CW

Hi,

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

Regards,

Chandra.

Thomas Dodds

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.

Christian Berg-0racle

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