ODV not retrieving all records from OBIEE analysis — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODV not retrieving all records from OBIEE analysis

Received Response
195
Views
17
Comments

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.

«1

Answers

  • Engrid Braholli
    Engrid Braholli Rank 3 - Community Apprentice

    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.

  • 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?

  • Engrid Braholli
    Engrid Braholli Rank 3 - Community Apprentice

    Hi all,

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

    thank you.

  • Joel Acha11111
    Joel Acha11111 Rank 5 - Community Champion

    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?

  • Engrid Braholli
    Engrid Braholli Rank 3 - Community Apprentice

    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.

  • Mark_Daynes
    Mark_Daynes Rank 6 - Analytics Lead

    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.17
  • Engrid Braholli
    Engrid Braholli Rank 3 - Community Apprentice

    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?

    .

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    Do you also have the corresponding query executed from the BI server?

  • Engrid Braholli
    Engrid Braholli Rank 3 - Community Apprentice

    Dear all,

    Has anyone else faced the issue described above with DV desktop?

    thanks.

  • Michael Verzijl
    Michael Verzijl Rank 6 - Analytics Lead

    What is the setting of ResultRowLimit on OBIEE side? Please check instanceconfig.xml and report back