Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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