Disperse groups — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Disperse groups

Received Response
21
Views
1
Comments

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

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    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>