Hi All ,
I have a prompt page showing product name,and users can do multi select.
Apart from display product names,i also want to show 2) 'All Products' (user can see data for all products) 2) Top 5 Products ( which will be calculated based on measure field,and if user select this static prompt choice,report should run only for top 5 products).
For 'All Products' i can put in detail filter like :- [Product_name] in ?prompt_product? or ?prompt_product?='All Products' .
'All Products' is static choice in prompt.
But i am not able to get how to show Top 5 Product option in prompt .Any suggestions!
Thanks!
Got to this link.
http://www.sourcetofind.com/how-to-display-multiple-rank-choice-to-user-at-prompt-value-in-reports-designed-using-cognos-report-studio/
Will try this.Looks like it will work.
Quote from: nsaxena on 25 Sep 2015 02:19:25 AM
Hi All ,
I have a prompt page showing product name,and users can do multi select.
Apart from display product names,i also want to show 2) 'All Products' (user can see data for all products) 2) Top 5 Products ( which will be calculated based on measure field,and if user select this static prompt choice,report should run only for top 5 products).
For 'All Products' i can put in detail filter like :- [Product_name] in ?prompt_product? or ?prompt_product?='All Products' .
'All Products' is static choice in prompt.
But i am not able to get how to show Top 5 Product option in prompt .Any suggestions!
Thanks!
Are you using a dimensional package or a relational package?
hi MFGF,
I am using relational model.