Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 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
Removing parameter values from CSV output
Summary
Removing parameter values from CSV output
Content
Hi guys,
I'm using BI Publisher 12.2.1.1 and I created a report directly from the data model in BIP. There are two parameters, p_start_date and p_end_date, used for the report. When generating the report in BIP as CSV with some supplied param values, it adds the param names to the header and the param values repeat for every row of output. I don't want the parameters to show at all in the output and I'm not sure why they would by default! I unselected the "show" checkbox in the Parameters dialog when editing the report as well but it did not fix the issue.
Any ideas?
Thanks,
Bill
Answers
-
Here's a way to exclude the params from the report:
Under the data model, there's a Properties link. Within Properties, there's a "Include Parameter Tags" option under XML Output Options. Deselecting this will remove the params from the report.
--
Bill
10 -
Thank you Wpateracki,
Your solution is still being used by people!
1 -
Thank you Wpateracki.
0 -
Hello, I can't find the options, this is able for OTBI? someone can share screenshots
0 -
Hi @DIEGXDNXP,
The solution that Wpateracki has suggested is for BI Publisher Report.
What issue are you facing? Is it related with OTBI Analysis? if Yes, please raise it in a new thread with all the required info so that someone can assist you.
Cheers,
0
