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

Row Limit? Missing Rows

edited Jul 15, 2020 4:19PM in Reporting and Analytics for HCM 4 comments

Content

Hi all - I have a query (Logical SQL) that I use to run for changes.  It runs Assignment and Salary changes.  When I ran the report in April, it pulled back ~132K rows (BETWEEN 2019-01-01 AND CURRENT_DATE).  I ran that same report today, and now I have about 13K rows.  

I notice there are people missing from the query as well.  So I ran the query, limiting it to someone I know was on the April report, and their data returns.  But if I remove that filter, they no longer appear on the report.

It's not a security issue, since I can see the data when I filter to one person, but that one person disappears on the final output (and I have access to all data, so should be no issue).

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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