Hi we are using OBIEE 11g. We have a prompt which is taking data from a table which has 100k records, some records were not showing up. When I checked the backend query that was generated, I was able to see something like this
SELECT "Customer"."Customer Name" saw_0 FROM "Sales"
WHERE UPPER("Customer"."Customer Name") LIKE UPPER('Rite%') ORDER BY saw_0
FETCH FIRST 65001 ROWS ONLY
The last part is actually limiting the number of rows fetched. I googled it and found few posts asking to change this value in EM->coreapplication->capacity Management->Performace and set "**Max no of rows processed when rendering a table view**" to a higher value than 6500.But this value is already set to 500k.
How do I get rid of this last limiting part of the query?