OBIEE 12C Export to Excel Issue — 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

OBIEE 12C Export to Excel Issue

Received Response
316
Views
15
Comments
user12058206
user12058206 Rank 4 - Community Specialist
edited Aug 13, 2024 6:05PM in Oracle Analytics Cloud and Server

How many rows we can Import to Excel 65000 max?? We are in OBIEE 12C. And on both Excel and PDF we can import 65000 max rows. We also opened a ticket with Oracle they say it's a bug and saying their Dev team is working on it.

«1

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Export settings are still in the instanceconfig.xml for the detailled control.

  • Uttaran Banerjee
    Uttaran Banerjee Rank 2 - Community Beginner

    try changing

            <ODBC>

                <ResultRowLimit>65000</ResultRowLimit>

            </ODBC>

    to a higher value in your instanceconfig.xml. if you have all the other parameters changed.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Oh yeah great idea. Go for one random parameter out of a list of minimum 20 possible ones without thinking about the rest or the impact....Seriously....

  • user12058206
    user12058206 Rank 4 - Community Specialist

    We tried everything and changed instanconfig.xml file but no use. Both excel and PDF not more than 65000 rows. it will throw error saying as please contact BI administrator. We have a Oracle SR opened from 2 months now Oracle saying it's a bug.

  • Uttaran Banerjee
    Uttaran Banerjee Rank 2 - Community Beginner

    I guess you may have also tried changing  <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload> for pivot and table views? Our envs export over 500000.

  • user12058206
    user12058206 Rank 4 - Community Specialist

    We did but no use.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What precise version are you using? Cause I never had this issue in any of the 3 major versions we had so far

  • user12058206
    user12058206 Rank 4 - Community Specialist

    we are on 12.2.1.0.0

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok maybe go to something more recent than a .0 release.

    You missed 12.2.1.1. and 12.2.1.2..

  • 3127517
    3127517 Rank 1 - Community Starter

    Hi,

    Did you get any solution to it? I am also facing the same issue