I've got an oracle datasource set up that has multiple signons to for different security views. In general, users get access to one signon but some power users have access to many. When the power users run a report through report studio they get prompted which signon to choose, but when they set up a job the reports fail with "Signon is Ambiguous" because cognos doesn't know which signon they want to use.
Is there a way to select a signon for each report in your job?
for each report under a job, when you hit the edit button, under 'Prompt Values' click on the checkbox 'Override the default values', and set up the connection.
Works - thanks!