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)?

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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