Can someone tell me whether we can apply filter on list of
values in the 'Value Prompt'? e.g. I have a value prompt
(named city) and the prompting is holding around 2000
cities but I want to apply filters on cities so users can
select only 15 cities out of 2000 and then run the report.
Users should be flexible enought to select any 15 cities
from the list. Is it possible. Please advice!
Answer Posted / sathish kumar
first you create value prompt as usual with parameter and applying the filter on city.
In the next step,you need to create the static choices to select the 15 cities among 2000.
And run your report..,
am sure you will definitively get the output.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
------------------What is Inline Query?
how to perform back drill through in cognos 8 what is the use of it
What do you mean by Drill down and Drill Up?
How can we Maintain the Cube Security by Category level and Dimension level ?
How to create model and how to test model?
What are the components of report net?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Explain what is the difference between microstrategy and cognos reporting tool?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What you mean by drill across and what is the difference between drill through, drill across?
What do you understand by ‘ibm predictive maintenance and quality’?
What are all the types of hierarchies?
What is an olap designer?
What are the two types of framework manager?