BI Publisher (MOSC)

MOSC Banner

Duplicate the parent row data for each child record

edited Sep 14, 2016 5:30AM in BI Publisher (MOSC) 4 commentsAnswered

The issue is stated below,

We need to duplicate the parent data for each child record.

<Tag>

     <parent_tag>

          <prow>A</prow>

               <child>A</child>

     </parent_tag>

     <parent_tag>

          <prow>B</prow>

               <child>A</child>

               <child>B</child>

     </parent_tag>

     <parent_tag>

          <prow>C</prow>

     </parent_tag>

</Tag>

The output required is,

   

prowchild
AA
BA
BB
C

             

The parent - child is a 1-M relationship and the layout is in a table format. If we add the for loop on the parent tag, then the parent data displays with the 1 child data only. However, we need to repeat the loop for all the child records and even show there parent value. So we tried adding the child loop and display the parent data but if a parent doesnt have a child data then the parent record would not show up too. This is was achievable in Actuate, however we need to replicate the same in BIP.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center