Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to group a xml data in RTF Template.

Question
2
Views
0
Comments
Mohammed Sulaiman
Mohammed Sulaiman Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi All,

Below you can see the sample XML data which i need to work in RTF Template. Here i need to group a data as follow.

First Group : PER_NUMBER

Second Group : CATEGORY_NAME

My expected result will be. i need to sum up the RUN value based on the category name and show the output for every employee.

OUTPUT format will be like

Person Number

Person Name

CATEGORY NAME

Total

Sample XML :

<GLB_PAY_ACTIVITY_REPORT> 

  <PA>

                <PA_INFO>

                    <EFF_DATE>2018-01-12</EFF_DATE>

                    <ACT_TYPE_NAME>Payroll calculation</ACT_TYPE_NAME>

                    <ACT_TYPE>R</ACT_TYPE>

                    <LDG_DEFAULT_CURRENCY_CODE>USD</LDG_DEFAULT_CURRENCY_CODE>

                    <PRA>

                        <OBJECT_ACTION_ID>176596</OBJECT_ACTION_ID>

                        <PRA_INFO>

                            <PER_NUMBER>1234</PER_NUMBER>

                            <PERSON_DISPLAY_NAME>ABC text</PERSON_DISPLAY_NAME>

                        </PRA_INFO>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Employee Tax Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Tax Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Employee Tax Deductions</REPORTING_NAME>

                            <RUN>1597.48</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                           <CATEGORY_NAME>Total Standard Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Earnings</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Gross Earnings</REPORTING_NAME>

                            <RUN>4840.8</RUN>

                                       </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Imputed Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Taxable Benefits</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Imputed Earnings</REPORTING_NAME>

                            <RUN>15</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Standard Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Earnings</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Net Payment</REPORTING_NAME>

                            <RUN>3068.48</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Pretax Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Pre-Statutory Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Pretax Deductions</REPORTING_NAME>

                            <RUN>135.5</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Voluntary Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Voluntary Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Voluntary Deductions</REPORTING_NAME>

                            <RUN>24.34</RUN>

                            </TOTALS_BAL>

                       </PRA>

                </PA_INFO>

            </PA>

                        <PA>

                <PA_INFO>

                    <EFF_DATE>2018-01-12</EFF_DATE>

                    <ACT_TYPE_NAME>Payroll calculation</ACT_TYPE_NAME>

                    <ACT_TYPE>R</ACT_TYPE>

                    <LDG_DEFAULT_CURRENCY_CODE>USD</LDG_DEFAULT_CURRENCY_CODE>

                    <PRA>

                        <OBJECT_ACTION_ID>176596</OBJECT_ACTION_ID>

                        <PRA_INFO>

                            <PER_NUMBER>1234</PER_NUMBER>

                            <PERSON_DISPLAY_NAME>ABC text</PERSON_DISPLAY_NAME>

                        </PRA_INFO>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Employee Tax Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Tax Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Employee Tax Deductions</REPORTING_NAME>

                            <RUN>1597.48</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                           <CATEGORY_NAME>Total Standard Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Earnings</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Gross Earnings</REPORTING_NAME>

                            <RUN>4840.8</RUN>

                                       </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Imputed Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Taxable Benefits</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Imputed Earnings</REPORTING_NAME>

                            <RUN>15</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Standard Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Earnings</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Net Payment</REPORTING_NAME>

                            <RUN>3068.48</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Pretax Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Pre-Statutory Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Pretax Deductions</REPORTING_NAME>

                            <RUN>135.5</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Voluntary Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Voluntary Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Voluntary Deductions</REPORTING_NAME>

                            <RUN>24.34</RUN>

                            </TOTALS_BAL>

                       </PRA>

                </PA_INFO>

            </PA>

                        <PA>

                <PA_INFO>

                    <EFF_DATE>2018-01-12</EFF_DATE>

                    <ACT_TYPE_NAME>Payroll calculation</ACT_TYPE_NAME>

                    <ACT_TYPE>R</ACT_TYPE>

                    <LDG_DEFAULT_CURRENCY_CODE>USD</LDG_DEFAULT_CURRENCY_CODE>

                    <PRA>

                        <OBJECT_ACTION_ID>176596</OBJECT_ACTION_ID>

                        <PRA_INFO>

                            <PER_NUMBER>1234</PER_NUMBER>

                            <PERSON_DISPLAY_NAME>ABC text</PERSON_DISPLAY_NAME>

                        </PRA_INFO>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Employee Tax Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Tax Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Employee Tax Deductions</REPORTING_NAME>

                            <RUN>1597.48</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                           <CATEGORY_NAME>Total Standard Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Earnings</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Gross Earnings</REPORTING_NAME>

                            <RUN>4840.8</RUN>

                                       </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Imputed Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Taxable Benefits</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Imputed Earnings</REPORTING_NAME>

                            <RUN>15</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Standard Earnings</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Earnings</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Net Payment</REPORTING_NAME>

                            <RUN>3068.48</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Pretax Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Pre-Statutory Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Pretax Deductions</REPORTING_NAME>

                            <RUN>135.5</RUN>

                        </TOTALS_BAL>

                        <TOTALS_BAL>

                            <CATEGORY_NAME>Total Voluntary Deductions</CATEGORY_NAME>

                            <BASE_CATEGORY_NAME>Total Voluntary Deductions</BASE_CATEGORY_NAME>

                            <REPORTING_NAME>Voluntary Deductions</REPORTING_NAME>

                            <RUN>24.34</RUN>

                            </TOTALS_BAL>

                       </PRA>

                </PA_INFO>

            </PA>

</GLB_PAY_ACTIVITY_REPORT>           

Note : These are all need to be done in RTF only.

Thanks in advance.....

Thanks

Sulaiman