Categories
- All Categories
- 99 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 55 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Oracle Data Visualization:Exporting or downloading a table in pivot format

Summary
Exporting a table in Pivot Format
Content
Hi All,
I am new to Oracle Data visualization.We have created a Pivot Table report in Oracle data visualization and we need to export it into excel file in same format. The challenge we are facing is that when we export it into csv file it gets converted into unpivoted form.
Is there any way that we can achieve this requirement or is there any separate tool specially to create these kind of reports in Oracle
Regards,
Bhargav
Answers
-
Hi Bhargav,
Looks like there is no option to export the pivot table in to Excel format. You can only export in CSV, PDF , PPT , ODV package formats.
The question is - what is that you want to do by exporting data to excel. The tool ODV is equipped with capabilities that allows users to analyse data with in the tool. What additional requirements is forcing you to upload to excel?
rgds
Mahesh K
0 -
Hi Bhargav,
I believe Mahesh is correct that it will not port like that. It's something that i've never seen it do.
Can I ask though .... can you add some more detail to this as I'm not quite sure what you are looknig for "....or is there any separate tool specially to create these kind of reports in Oracle"?
Mark
0 -
A pivot table by its form and design can hardly be expressed as a CSV.
CSV is for pure data exports. And not formatted data!
0 -
Hi Mark ,
Thanks for replying
I have earlier worked on QlikSense where they have a separate tool called Nprinting specially meant for creating excel ,pdf or ppt reports. So I was thinking that whether there is simliar kind of tool in Oracle Data Visualization
Regards,
Bhargav
0 -
May be you should consider using "Analytics Classic" if you are on cloud, which is OBIEE 12c on Cloud. OR OBIEE 11 or 12c version on-premise. where you will have more flexibility on the exports
Regards
Mahesh
0 -
Well, Oracle of course have a lot of tools available and it all depends 'what you need to do'. For example, I've used SmartView to connect Excel to a subject area and show the capbility of creating a pivot in Excel based on BI data. So, pulling data and structures rather than pushing. I've always gone back to the customer to find out what is the business problem they are trying to resolve though - you can do a lot without exporting.
Mark.
0 -
Amen. Amen to that so much.
Stubborn insistence on any one, given tool results at best in poor, suboptimal workarounds and at worst in unmaintainable hacks.
Right tool for the right job. Answers, BIP, DV, SmartView...the options are legion.
0