suppose a value prompt contains 100 values and i want to
select all values in that prompt....i want ALL option in
the value prompt? how can u keep this option in value
prompt?
Answer Posted / vij
hi Vijay,
In your value prompt add the static chioce as 'All'
and in filter put the expression as....
(column in (?Parameter1?)) or (?Parameter1?='All')
hope this may help u :)
vij
| Is This Answer Correct ? | 17 Yes | 6 No |
Post New Answer View All Answers
what is the difference between filter and condition?
What actually a project contains?
----------------Describe DWH Architecture?
What is the function of model design accelerator?
How create measures and dimensions?
Can you explain the advantage of using shortcuts?
Define metrics studio?
What is drill down and slicing and dicing whats the difference between them?
What is meant by junk dimension?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is meant by Reportstudio shortcut?
How the Bursting happens in same report and how to Print the bursting Report?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What are the types of studio present in Cognos?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?