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

bursting query

edited Nov 25, 2019 3:40PM in Reporting and Analytics for HCM 3 comments

Summary

Bursting Query

Content

Hello. I had to build a data model for a report and RTF letter. The values in the letter are based on the attached SQL. When I run the report, there are 7 separate records but when I run the RTF template report, only the first record is returned. I built a bursting query but I still see only one letter when I run the report. I am new to bursting queries so I am unsure what else I need to do.

SELECT

 "Workforce Management - Worker Assignment Event Real Time"."Worker"."Person Number"  KEY,

   'RTF Template' TEMPLATE,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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