Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Is there a way to show specific columns when exporting?
Our reports have lots of columns but is there a way to limit the number of columns or specify which column to be included when we export?
Thanks
Joe
Answers
-
Reports? You're talking about BI Publisher then?
If not and you're talking about "analyses" - which are technologically different objects - the ability to choose columns is what Answers and DV are all about. You have two self-service portals which support that.
0 -
I'm taking a shortcut on Christian's answer and assume you talk about OBIEE Answers (based on some of your previous threads, but if you mention the product & version it would make life easier ...).
When exporting there is the "Formatted" type of exports which will return you the content of the view you are exporting, or the compound layout, and there is the "Data" type which exports the result of the query generated based on the "Criteria" tab of your analysis.
Based on that you easily see that if you want to export only a subset of columns based on the "Criteria" of your analysis you must stay away from "Data". But if you build a view using only a subset of columns and expose that specific view in a page and enable the export link there, you should be able to get close to what you are after.
Don't expect a prompt asking you to pick the columns you want. You can of course get to something like that, but it means having an analysis which is built fully dynamically and this required quite some work to develop and maintain it etc.
The tool will allow you to achieve almost anything, but the price for it can be quite high ...
0 -
Thank you @Christian Berg and @Gianni Ceresa
Sorry about the not specifying if it is the OBIEE Anwsers or BI Publisher, I am referring to the OBIEE Anwsers/Analysis
Thanks Gianni for the explanation between data type and formatted type of exports.
So if I build a view using only a subset of columns and expose that specific view in a page as analysis, that analysis will have the export link as you said and if the user chose to export as CSV, dont they get all columns in the criteria regardless of what is being exposed in a view? I know if they export as excel maybe they get only what ever columns being exposed but not as CSV, am I wrong? thanks
Joe
0 -
Yes. "Data" exports everything in the criteria. Not just what's used in a view.
0 -
So when we add the export link, the user has the option to export as DATA>CSV...therefore there is no option for us to show or hide specific columns in the export? per the original question. or is there and I missed it?
Thanks
Joe
0 -
Nope. Once more: choosing what you export is self-service functionality in Answers / DV
0 -
Ah ok, I understand - thanks for confirming @Christian Berg
0
