"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)? — Cloud Customer Connect
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

"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?

edited Dec 8, 2023 9:08AM in Reporting and Analytics for HCM 2 comments

Summary:

I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area analysis.

  • Custom logical SQL would normally cause the Subject Areas in the analysis to display as "Invalid Subject Area", but this one doesn't, it behaves completely 'normally'.
    • This analysis has four select statements (joined with UNION ALL)), but there is no evidence of this on the "Criteria" user form.
  • Moreover, when I copy and paste the SQL back into a "new analysis", it then reverts to normal behaviour (i.e. displays "invalid subject area")
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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