Payroll - Element Entries subject area not returning data in production
Summary
In production, for the Payroll subject are, adding more than one dimensions results in no dataContent
We have a report with multiple UNIONS, but the main subject area that we get most of the common dimension data like Worker details, etc. comes from the Payroll - Element Entries. The report works in TEST but not in PROD. Most columns come back empty in PROD.
We experimented and found combine any two dimensions in the from the Payroll - Element Entries in PROD environment results in "No data found" . Even a simple analysis with Worker + Grade or Worker + Location. The same simple query in TEST works. Also, the same simple query in PROD, but using a different subject area, like Workforce Management - Assignment works. Only this subject area in PROD environment.