Oracle Analytics and AI

Alexander Restrepo

Summary

Disperse groups

Content

Hi All,

I have 3 groups 1 header, 1 details, and 1 totals.

The XML file generated, its exporting each group as group itself at the same level header, details and total.

I need to show header then details, and finally total for each group.

Please check the attached documents for reference.

I got something like

<Header>

headfield1

headfield2

</Header>

<Details>

Detail1

Detail2

Detail3

</Details>

<Total>

total

</Total>

I need a excel output similar to the jpg file

Thanks

Brajesh Shukla-95078

You need to change the way you are generating your XML.

Please generate the XML as below way

<Header1>

    <Detail1>

</Header1>

<Header2>

    <Detail2>

</Header2>

<Header3>

    <Detail3>

</Header3>

.

.

.

.<Total>

</Total>