Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
ODV not retrieving all records from OBIEE analysis
Summary
ODV not retrieving all records from OBIEE analysis
Content
Dear all,
I am trying to achieve an integration of ODV Desktop with Oracle BI EE. We have latest version of ODV and OBIEE version 11.1.1.9.0.
I am able to create a dataset from a pre-build BI Analysis and I am able to retrieve records in ODV. The issue is that for some reason not all records of the analysis are retrieved into ODV.
When I access the analysis from OBIEE I am able to downloan all the records of the report into a CSV file. But ODV is not retrieving all the records and I dont know why.
I have increase all the parameters inside the instanceconfig file of OBIEE into big numbers.
Can you please suggest for any reasons why is this think happening when connecting ODV with OBIEE?
I tested the same query from ODS with direct database access and in that case it is retrieving all the records.
Will appreciate your support.
regards.
Answers
-
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.
0 -
Hi,
If you look in the log where you find the query sent to the source (OBIEE in your case), do you see a "LIMIT" clause inside the query?
0 -
Hi all,
Can you please provide any feedback on the above, because I am still facing the same situation.
thank you.
0 -
and when you run the query that is in the obis1-query.log file directly on the database (TOAD,SQL Developer), do you get the correct results?
0 -
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.
0 -
Hi,
Great pointers from the guys above - What I was wondering is about volume - is this a huge dataset? - can you tell us how many records are returned in BIEE and how many in DV.
Also, have you tried taking the data straight from the subject area - effectively creating a variant of the analysis in DV.
Mark
1.0.0.170 -
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 records, the simple report I am currently trying to work with has:
-- in obiee it has 1,186,000 (all records are exported in CSV file from obiee)
-- while in DV it looks like it downloads only 1,100,001
I tried to download the file in csv from DV by building a project but now I am getting the following error:
Exceeded configured maximum number of allowed input records. ResultRowLimit(table) OR CubeMaxRecords(Pivot/Chart) needs to be reset in the config file. Please check with your administrator. I found some config files on the path "C:\Users\<username>\AppData\Local\Temp\DVDesktop\config\fmwconfig" and incresed the limits there but it looks like they are getting replaced everytime I open DV desktop, so the situation is the same when downloading the file in csv. Is there any other path where I can file DV Desktop config file?
.
0 -
Do you also have the corresponding query executed from the BI server?
0 -
Dear all,
Has anyone else faced the issue described above with DV desktop?
thanks.
0 -
What is the setting of ResultRowLimit on OBIEE side? Please check instanceconfig.xml and report back
0
