Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE 12C Export to Excel Issue
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.
Answers
-
Export settings are still in the instanceconfig.xml for the detailled control.
0 -
try changing
<ODBC>
<ResultRowLimit>65000</ResultRowLimit>
</ODBC>
to a higher value in your instanceconfig.xml. if you have all the other parameters changed.
0 -
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....
0 -
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.
0 -
I guess you may have also tried changing <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload> for pivot and table views? Our envs export over 500000.
0 -
We did but no use.
0 -
What precise version are you using? Cause I never had this issue in any of the 3 major versions we had so far
0 -
we are on 12.2.1.0.0
0 -
Ok maybe go to something more recent than a .0 release.
You missed 12.2.1.1. and 12.2.1.2..
0 -
Hi,
Did you get any solution to it? I am also facing the same issue
0