Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Custom Export Link for Exporting All the rows in Report
Hi friends,
Im in obiee 11.1.1.9.6.
For each and every report i have enabled report links which gives the options like Export etc.
When i tried to Export the rows to Excel it is exporting 2500 rows, according to the default value set in EM>CapacityMgmt and that is fine.
My requirement is to have a custom Export to Excel link and on clicking that link it needs to export all the rows in the report and it should not restrict to the 2500 rows..Is it possible to create the custom Export to Excel link which inturn need to export all the rows wrt to the prompted values in the dashboard.
Thanks in advance.
Regards,
Saro
Answers
-
Saro wrote:Is it possible to create the custom Export to Excel link which inturn need to export all the rows wrt to the prompted values in the dashboard.
No. All exports are governed by the limitations set in the instanceconfig.xml ... and not jsut that one lien, there are tons of others.
You may add a link to a BI Publisher report object for export though. Different technology. Different limitations.
0 -
Hi Berg,
Thanks for the reply.
Custom link Export case is not possible like you have said and that is fine.
My second thought option is: Is it possible to control the std export limit rows based upon the user.
Like, for an example: If User A exports the report, it need to export only 2500 rows(irrespective of the number of rows displayed..Suppose in my case if the report has displayed 5000 rows then it has to export only 2500 rows for the User A)
Suppose if User B exports the report, then it need to export all the rows in the report...suppose if the report has 5000 rows then it has to export all the 5000 rows for the User B.
Is the above case is achievable of restricting the user based excel export download.
Though, i see the limiting rows according to the user in the report option is available, but not the export rows limitation according to user.
Regards,
Saro
0 -
The number of rows exported in Excel is defined by a system wide setting, so this one can't be user based.
The Excel export will contains not more than the export limits defined in the system, but not more than the rows the users is allowed to query.
So if you limit rows on the users that limit will apply both to the analysis on the screen (the web page) and the export.
You can't set a limit only for the export, it's either everywhere (because the limit is set in the query itself) or nowhere.
0 -
Hi Saro,
I don't think you are understanding.
There are limits, but they are universal limits applied by a single file.
You can put the numbers up, but it is for everyone, there is no user / analysis / dashboard 'level' based limits.
0 -
Thanks Gianni and Angel for your opinions.
0 -
Those aren't "opinions". Those are "facts" and precisely the facts I would have told you myself as well.
0 -
Oops, sorry for the wrong word. Thanks for letting me know about the Facts:-)
Saro
0 -
No worries. Just wanted to point out that we only deal in opinions when we explicitly state so
0
