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?>