Matrix Report Output

We can use below tags/syntax for developing complex matrix reports. We can use below concepts both in RDF report templates and fusion BIP Report outputs.

Sample Use Case

We need to develop a report which shows Department details in ROW and Job details in COLUMN for the employees

Department	Step2 JOB Step3
Step1 DNAME	Step4 ENUMBER Step5 Step6

Note: Please use actual XML tag value in above mentioned Bold Capital Letters place

Step 1: <?for-each-group:G_1;./DNAME?><?variable@incontext:DNAME;DNAME?>

Step 2: <?for-each-group@column:G_1;./JOB?>

Step 3: <?end for-each?>

Step 4: <?for-each-group@cell://G_1;./JOB?><?if:count(current-group()[DNAME=$DNAME])?><?end if?>

ENUMBER: <?current-group()[DNAME=$DNAME]/EMP?>

Step 5: <?end for-each?>

Step 6: <?end for-each?>

Load XML file and verify the output file

We can also add Horizontal and vertical totals if require

Horizontal Total:

                    <?sum(current-group()/ENUMBER)?>

Vertical Total: 

                    <?for-each-group@cell://G_1;./JOB?>  

                    <?sum(current-group()/ENUMBER)?>

    

Grand Total : <?sum(ENUMBER)?>