Oracle Transactional Business Intelligence

Products Banner

BI Publisher Excel - How to get multiple horizontal repeating groups working?

257
Views
6
Comments

Content

Hello There,

I would like to know how can I get the below output using BI Publisher for Excel.

I have three groups in the xml file.

G_1  ->  G_2 ->  G_3

Below expected output:

G_1 G_2 G_3
Segment1 Creation_Date Line_Num Item_ID Quantity_Ordered Quantity_Delivered
10001008 08 11 2019 10 300000013603844 200 100
    20 300000013612944 300 200
    30 300000013615636 10 5
    40 300000013626474 20 1
    50 300000013676169 2 2
10001009 22 11 2019 10 300000014432708 11 11
    20 300000014437123 25 25
    30 300000014434715 6 6
           

 

The output I am getting now is as below:

G_1 G_2 G_3
Segment1 Creation_Date Line_Num Item_ID Quantity_Ordered Quantity_Delivered
10001008" rowMark="2 2019-11-08T04:35:17.000+00:00" rowMark="2 10" rowMark="3 300000013603844" rowMark="3 200 100
    20" rowMark="3 300000013612944" rowMark="3 300 200
    30" rowMark="3 300000013615636" rowMark="3 10 5
    40" rowMark="3 300000013626474" rowMark="3 20 1
    50" rowMark="3 300000013676169" rowMark="3 2 2
10001009 22 11 2019 10" rowMark="3 300000014432708" rowMark="3 11 11
    20" rowMark="3 300000014437123" rowMark="3 25 25
    30" rowMark="3 300000014434715" rowMark="3 6 6
         

 

Please find attached the sample xml, output and the excel template file for your reference.

Look forward to hearing from you.

Thank you & regards,

Donald

Comments