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
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.
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 ...
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
Yes. "Data" exports everything in the criteria. Not just what's used in a view.
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?
Nope. Once more: choosing what you export is self-service functionality in Answers / DV
Ah ok, I understand - thanks for confirming @Christian Berg
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
