• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 852
  • Last Modified:

Create a Cognos Report with three queries for multiple values

I am asking for instructions on how to write a cognos report with three queries that would be able to use multiple values from a value prompt without combining the three queries to just a single query.
1 Solution
It's little confusing.
Do you have to use prompts or can you simply use hard coded filter in each query?
If you can use filters in each query/list, it'll run independently of other queries.

If you want to pass prompt values to 3 queries in the report, there is no direct way to choose what value to use for what query. All queries must use the same values from one prompt.

If you want to separate each query to run different prompt values, you have to create 3 prompts and filter each prompt to corresponding query.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now