Can you add a prompt to an analysis that uses a left outer join (or any join)?
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:
1