OTBI Analysis Prompt returning an error
Summary
A number of prompts created the same way, but only one is throwing an errorContent
Hi, I have created an anlysis in OTBI and added a number of prompts all with the same options, e.g. 'Choice List' as the User Input type. When I come to open the report, all of the prompts will display a list of values to choose from, except for one. This one displays a message saying "Failed to load(Odbc driver returned an error (SQLExecDirectW).)"
Can anyone shed any light for me as to the reason for this? Is it specific to the column concerned ? It is the Absence Status column from the Workforce Management - Absence Real Time subject area, within the Assignment Absence Details folder.