Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Dynamic Grouping in RTF
Summary
Dynamic Grouping in RTF
Content
Is it possible to have group by based of input parameter passed in XML for example user may pass to GROUP BY DEPTNO OR JOB OR AGE OR no GROUP BY at all.
Answers
-
Yes possible ,
1) first define parameter <?param:deptno?>
2) use parameter as grouping element as <?for-each-group:/DATA_DS/G_1;./$deptno?>
Thanks
0 -
upload RTF and xml , will send modified one , Thanks
0 -
I'm new to BI, my might not be clear or didn't asked correctly, it is about building RTF in word, user passes parameter GROUP_BY_OPTION in xml as
<GROUP_BY_OPTION>1</GROUP_BY_OPTION>
IF (GROUP_BY_OPTION ='1') THEN
group_by deptno
display deptno
group_by area
display area
display field1 field2 fiedl3 field4 field5 field6
end group_by area
display area_total :999
end group_by deptno
display deptno total: 999
ELSE IF (GROUP_BY_OPTION ='2') THEN
group_by proj_mngr
display proj_mngr
display field1 field2 fiedl3 field4 field5
end group_by proj_mngr
ELSE
display field1 field2 fiedl3 field4
END IF
Thanks again for quick reply, any help would be appreciated.
0 -
Thanks for the reply, I guess I got it working as below.
<?if:IN_GROUP_BY=’1’?>
group_by deptno
display deptno
group_by area
display area
display field1 field2 fiedl3 field4 field5 field6
end group_by area
display area_total :999
end group_by deptno
display deptno total: 999
<?end if?>
<?if:IN_GROUP_BY=’2’?>
group_by proj_mngr
display proj_mngr
display field1 field2 fiedl3 field4 field5
end group_by proj_mngr
<?end if?>
<?if:IN_GROUP_BY=’0’?>
display field1 field2 fiedl3 field4
<?end if?>
Thanks again.
0