Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI 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