Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

BI repeating group within repeating group

Received Response
31
Views
3
Comments
RichardvanMaaren
RichardvanMaaren Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Summary

BI repeating group within repeating group

Content

Hello,

Question on creating a BI report with repeating groups.

Stucture should look like this.

<for each repeating group>

data

               <for each repeating grouo>

                         data

               <end>

<end>

It seems this is not possible in BI is this correct ? Report is feeded with XML data.

Answers

  • RichardvanMaaren
    RichardvanMaaren Rank 2 - Community Beginner

    Hi,

    Thank your for your answer ! Will check the documentation

    XML is like :

    <Batch>

      <Payment>

          <Invoices>data</Invoices>

          <Invoices>data2</Invoices>

    </ Payment>

    <Payment>

          <Invoices>data</Invoices>

         <Invoices>data2</Invoices>

         <Invoices>data3</Invoices>

    </ Payment>

    <Payment>

          <Invoices>data</Invoices>

    </ Payment>

    </Batch

  • Sherry George
    Sherry George Rank 7 - Analytics & AI Coach

    Possible, but really you have to show us some sample XML and desired output. Here is an Oracle doc that show's how to do it.

    https://docs.oracle.com/cd/E28280_01/bi.1111/e22254/create_rtf_tmpl.htm#BIPRD2519

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

    Could let me us know what is your repeating group tag e.g. batch, payment, invoice etc.?

    based on that you can use for-each or for-each-group