oracle11g - FETCH FIRST 65001 ROWS ONLY-OBIEE 11g -

Hi, we are using obi 11g. We have a signal that is taking data from a table, in which 100k records Some records were not displayed when I checked backend query, so I was able to see something like this

  SELECT "customer" Sade FITEH first 65001 ROWS only by "Customer Name" where saw_0 from where "sale" outer ("customer". "Customer name") order such as 'sanskar%' order  

The last part is actually limiting the number of rows I went to it and found some terms to replace this value in EM-> core applications-> capacity management-> asms and " A table view Processed Process When Presenting Set the maximum number of "6500" for a value greater than "". But this value is already set to 500k.

How do I get rid of this last limited portion of the query? < / P>

There is an Oracle Knowledge article for this,

It indicates that you have instanceconfig Edit the .xml and & lt; ServerInstance & gt; tag it's obviously determined for the price you want

   gt; ; MaxDropdown Value & gt; X XXX & lt; / MaxDropDownValues ​​& gt; & lt; / sign & gt;  

The 6,500 price already has a lot for a selection-based signal.