BIPublisher Report Exports only 1500 records out of 20,000 records — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

BIPublisher Report Exports only 1500 records out of 20,000 records

Received Response
82
Views
13
Comments
3515130
3515130 Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

BIPublisher Report Exports only 1500 records out of 20,000 records

Content

Hi All,

I do have a BIPublisher report where in it displays 20,000 records but when I export the report into Excel it only exports 1500 records out of 20.000. Below are the details of the OBIEE version we are using. Some one please provide me the steps to resolve the issue.

Note:- There is no aggregations using in the query.

OBIEE version  Oracle Business Intelligence 11.1.1.7.140715

SQl Server DB version 2008 SP2

Thanks,

Ashwin

«1

Answers

  • 3515130
    3515130 Rank 3 - Community Apprentice

    Hi ,

    Its an Interactive report.

    Thanks,
    Ashwin

  • 3515130
    3515130 Rank 3 - Community Apprentice

    Hi Hendrick,

    Thanks for your reply. Let me go through the doc and will get back to you if needed.

    Thanks,

    Ashwin

  • 3515130
    3515130 Rank 3 - Community Apprentice

    Hi ,

    Thanks for your reply. Layout is RTF.  let me explain you the flow

    1) Using SQL created Data Model

    2) created the Report

    3) When try to export the report into Excel then I can see only 1500 records out of 20,000 Records. Attached is the screen short.

    Please do advice.

    Thanks,

    AshwinRow_Count_Issue.PNG

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    Can you try to export to CSV and check rows ?

    Layout is RTF or EXCEL ?

  • Hendrik Schmidt
    Hendrik Schmidt Rank 4 - Community Specialist

    Hi

    perhaps related to

    or

    or

    more as 65K data?

    regards

  • 3515130
    3515130 Rank 3 - Community Apprentice

    Hi ,

    It is an interactive report. I have attached the screen short too. When I download to CSV  it is exporting as expected.

    Thanks

  • 3515130
    3515130 Rank 3 - Community Apprentice

    Hi ,

    Please some one help me with the steps to resolve the issue.

    Thanks

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Hi Ashwin

    I can see from your screen shot that this is not an RTF template but its a web based template built in the online template builder. I see you have a couple of parameters in the report that are set to show all values. One thing to check with the interactive mode is that you have not filters the data by either clicking on a chart or on a column header in the table.

    You might also check the template itself and make sure you have not inadvertently added a hidden filter in the layout.

    If you have not done that. Id recommend creating a new template with just a table in it to show the data. Run it and then export that.

    If you are getting all 20K rows, then there is some filter at work in the other template.

    If there are not 20K rows, then there is some other issue. I doubt it will be the data model as you are successfully exporting to csv. When you select csv, there is no layout template involved, BIP just pushes the data out directly from the data model.

    At that point, I think you would need to log an SR with support to get more direct help.

    Cheers

    Tim

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    Can you try Excel (mhtml) output ? As i assume the columns /rows are being merged ?

    Also check


    --Yugandhar

  • 3515130
    3515130 Rank 3 - Community Apprentice

    Hi YGUTTIKONDA,

    I tried as you suggested unfortunately not working. Please suggest.

    Thanks,

    Ashwin