Dynamic Column data population in Excel Template

Ttarang

Summary

Dynamic Column data population in Excel Template

Content

Hi,

I have requirement to create a analysis batch analysis report in Oracle Fusion HCM R11 BI Publisher.  Data XML contain Parent data group (Header data) as well as child data group (Lines). Child data group is dynamic in nature and should be sub lines data should be transposed and populated as columns for each line row data.

Does anybody can help me out to do in Excel template.?

Attached my sample XML

G_2 should be the repeating group and G_3 should be transposed and dynamic in nature.

Output should be look like as below (4th column onward dynamic)

Task	Task Action	Line Status	Effective As-of Date	Element	Assignment Number
Element Entry	Delete Element Entry	Transferred	2/13/2017	DMTN 401K Loan 3	E54750
Element Entry	Delete Element Entry	Transferred	2/13/2017	DMTN 401K Loan 1	E55627

Share your ideas and insights on this would help others too.

Thanks in advance

Tarun

                                  

Task	Task Action	Line Status	Effective As-of Date	Element	Assignment Number
Element Entry	Delete Element Entry	Transferred	2/13/2017	DMTN 401K Loan 3	E54750
Element Entry	Delete Element Entry	Transferred	2/13/2017	DMTN 401K Loan 1	E55627