You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

BIP - Merging rows using an eText Template based on a condition

edited Apr 5, 2018 7:16AM in Reporting and Analytics for HCM 1 comment

Summary

The XML returned contains multiple rows for an employee, the requirement is to merge them all into one row using an eText Template

Content

Hi,

We have a requirement to build a report having the Employee Information and Benefit Plan information (based on plan type) in one row.

I am attaching the sample XML and eText template.

Currently, the output is generated as:

Charles, Brendon|HR Welfare Program|Medical|HR Medical Plan
Charles, Brendon|HR Welfare Program|Dental|HR Dental Plan

The requirement is that the output should be generated as shown below:

Charles, Brendon|HR Welfare Program|HR Medical Plan|HR Dental Plan

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!