I am trying to create a BIP report using an Excel template file.
I have installed Oracle Analytics Publisher Desktop (Ver. 12.2.5.5.0) and am using Excel to map fields from XML data to specific positions within an Excel worksheet.
The report I want to create is a form where a header (one row) is paired with detail rows (two or more rows). However, I cannot use Excel’s sheet-splitting functionality, and I would like to know how to implement this.
The image below illustrates what I am trying to achieve.
I referred to the manual and set the XDO_METADATA tags, but I am unable to control the output as expected.
I thought that setting the following might solve the issue:
XDO_SHEET_?XDO_SHEET_NAME_?
If you have any good suggestions or approaches, I would appreciate your guidance.
