I am using Cognos 10.2 Report Studio.
I have determined the Top 5 Products by Reveue % in my queries for the year 2017 & 2018. The user wants to Industry level % to be input by the user on the prompt page for Product.
So that chart displays Top 5 Products as a bar chart. The bar chart will have 3 bars - one for 2017, second for 2018, and the third one as the Industry Level % entered on the prompt page.
How do I pass that parameter value typed on the prompt page(text box prompt) to tie in with that respective product?
One solution I though is I can have a Pass Through SQL with #sq prompt code to fetch the prompt parameter values. But how do I dynamically determine that 5 values entered on the prompt page be tied to the Top5 Products in the query?
Just add a data item that uses the parameter.