How to create Matrix report / Pivot Report using Oracle BI Publisher
Step by step instruction:
1. Make data model using Oracle Reports Developer
2. Generate a XML output
3. Create a blank document in MSWord
4. Load the XML file from BI Publisher tab
5. Create a simple report using the Table Wizard
6. Change the Properties of the column as per instruction
<?for-each-group:G_DNAME;./DNAME?><?variable@incontext:DNAME_;DNAME?>
<?for-each-group@column:G_DNAME;./JOB?>
<?for-each-group@cell://G_DNAME;./JOB?><?if:count(current-group()[DNAME=$DNAME_])?><?end if?>
<?current-group()[DNAME=$DNAME_]/EMP?>