Oracle XML Publisher Matrix Report / BI Publisher
XML DATA Flow
C_for: <?for-each-group@column:Q_MAIN;ACTIVITY?>
ACTIVITY: <?ACTIVITY?>
C_end: <?end for-each-group?>
Col_for:<?for-each-group@column:Q_MAIN;ACTIVITY?>
HOUR: <?CF_HOUR?>
MAN_HOUR:<?CF_MAN_HOUR?>
Col_end: <?end for-each-group?>
M_for: <?for-each-group@section:Q_MAIN;./ DEPT_DATE?> <?variable@incontext:DESC;DEPT_DATE,REASONS?>
DEPT_DATE:<?DEPT_DATE?>
RESO: <?NON_PROD_EQIPMNT?>
R_for: <?for-each-group@cell://Q_MAIN;./ACTIVITY?>
S_HOUR:<?if:count(current-group()[DEPT_DATE=$DESC])?> <? sum(current-group()[DEPT_DATE=$DESC]/NONPRODHOUR)?>
<?end if?>
S_MAN_HOUR: <?if:count(current-group()[DEPT_DATE=$DESC])?> <?sum(current-group()[DEPT_DATE=$DESC]/MAN_HOURS)?>
<?end if?>
R_end:<?end for-each-group?>
ENG_WORK:<?ENG_WORK?>
OTHER: <?OTHER?>
M_end: <?end for-each-group?>
for: <?for-each-group@cell://Q_MAIN;./ACTIVITY?>
G_S_H: <?sum(current-group()/NONPRODHOUR)?>
G_S_MH:<?sum(current-group()/MAN_HOURS)?>
end: <?end for-each-group?>