Hi all, Does anyone have any update on this issue? Has anyone else been facing the same thing with ODV? thank you.

Yes, even when I was testing in the beginning I was getting less rows (like 65,000 rows). I increased some of the other OBIEE instanceconfig parameters to higher values and now its getting around 1M rows, but still not all of them. As mentioned in one of the above posts I found also an instanceconfig.xml file that ODV has…

Dear all, Has anyone else faced the issue described above with DV desktop? thanks.

Hi Michael, On OBIEE side the ResultRowLimit has the following value: <ODBC> <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control--> <ResultRowLimit>10000000</ResultRowLimit> </ODBC> thanks

HI, I see the below query being generated in the DV logs for BI: [2018-04-05T12:14:25.618+02:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 2b20] [messageid: USER-16] [requestid: fffe0005] [sessionid: fffe0000] [username: weblogic] -------------------- Execution plan: [[ RqPopulate <<1085>> [for database 0:0,0]…

Below is the query that is generate on BI server side: [2018-04-05T12:00:28.146+02:00] [OracleBIServerComponent] [TRACE:2] [] [] [ecid: e80f8094b3c2d8a3:-18fc1428:1626207411d:-8000-000000000003601a,0:1:17:3] [tid: 11f8] [messageid: USER-0] [requestid: 4a3b0006] [sessionid: 4a3b0000] [username: biadmin]…

Hi, In response to Mark_Daynes questions. I tried various ways to build the report and retrieve the data in DV ie. by creating a version of the report directly from subject area in DV, by creating the dataset based on an analysis already build in obiee. the nr of records retrieved is always the same. In terms of number of…

Hi, Yes I am able to execute the query direclty on the database (with TOAD) and it is showing all the records. Also the report that I have build in BI is displaying all the records and I am able to download all the records in CSV file from OBIEE web interface.

Hi all, Can you please provide any feedback on the above, because I am still facing the same situation. thank you.

Hi, I guess the log file to be checked is ...\OBIS\obis1-query.log. I have checked the log file and the query that is being generated but there is no "LIMIT" clause on the query. thank you.