Fill group by data in Group by columns and sub totals in a BI Publisher report

Sachin Mistry, CFA, PMP

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

1. Unmerge data in Group by columns such as PO Number, Buyer, Supplier Name and repeat cell values
2. Carry data group by columns data to sub total lines

See the attached pdf

How can I go about achieving the desired output?

Tushar.Gupta-Oracle

This could be of help:

http://ecapitaladvisors.com/blog/obiee-11g-unmerge-cells-when-downloading-obi-reports-to-excel/

Sherry George

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 ?

Tushar.Gupta-Oracle

Sure thing. Creating the SR would help.

PS: Please mark this thread helpful/correct, so that someone else with similar requirements could refer it.

Sachin Mistry, CFA, PMP

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.

Sachin Mistry, CFA, PMP

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.

Sachin Mistry, CFA, PMP

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.