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

Can you add a prompt to an analysis that uses a left outer join (or any join)?

Accepted answer
80
Views
5
Comments
edited Nov 27, 2018 7:37PM in Reporting and Analytics for HCM 5 comments

Content

I have created an analysis that pulls in data from the "Workforce Succession Management - Talent Pools Real Time" subject area and the "Workforce Profiles - Person Profile Real Time" using a left outer join, this works as intended. I would like to add a prompt to this analysis, prompting for "Employee Name"and "Pool Name". When I tried to add the prompt to run from the analysis, I get a message of "failed to load (Odbc driver returned an error (SQLExecDirectW).)". Any ideas on how to add a prompt when using an outer join for either an analysis or dashboard?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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