Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Fill group by data in Group by columns and sub totals in a BI Publisher report
Summary
Fill group by data in Group by columns and sub totals in a BI Publisher report
Content
Current Output
1. Group by column data is merged
2. Group by column data is not carried over to subtotal column
Desired output
- Unmerge data in Group by columns such as PO Number, Buyer, Supplier Name and repeat cell values
- Carry data group by columns data to sub total lines
See the attached pdf
How can I go about achieving the desired output?
Answers
-
This could be of help:
http://ecapitaladvisors.com/blog/obiee-11g-unmerge-cells-when-downloading-obi-reports-to-excel/
0 -
Hi,
You could get a quicker answer if you post this in the BI publisher forum.
For now, what is the template type and is there a sample XML you could share ?
0 -
Sure thing. Creating the SR would help.
PS: Please mark this thread helpful/correct, so that someone else with similar requirements could refer it.
0 -
Sherry,
Appreciate your help. I will post this to BI Publisher forum. The template type is xpt. Bec of confidential data cannot share sample xml.
0 -
Tushar, This is of great help and exactly the kind of fix that should help. We using Oracle Fusion Cloud, so I am not sure if this will work but I will create SR and request if support can help us implement this.
0 -
Unfortunately this did not solve the problem. Per Oracle support what you are suggesting is applicable to OTBI export from a dashboard and is not related to BIP reports.
0