Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BI Publisher Excel - How to get multiple horizontal repeating groups working? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

24
Views
5
Comments
edited Dec 11, 2019 9:56AM in General Transactional Reporting (OTBI) 5 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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!