how to get the all values from a prompt using 'ALL' use and
display value in prompt

Answer Posted / venkatesh

In your value prompt add the static chioce as 'All'
and in filter put the expression as....

(column in (?Parameter1?)) or (?Parameter1?='All')

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the importance of having monitor service in cognos?

571


What is the difference between a cascading report and drill through the report?

723


what is degenerate key in oracle ?whare do we use it?

2051


What do you understand by the term 'model durability'?

560


How do you Parametermap variables in Quiries?

1754






Define dimensions?

608


What do you understand by the term 'aggregate advisor?'

531


What is a Cube?

680


How create measures and dimensions?

593


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3142


what are the dimensions that you have in your current project?list them?

1628


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

581


Explain the difference between powerplay transformer and power play reports?

590


how you migrate reports to cognos 8 from previous versions?

619


tell me two or three issues from client side and how to solve those issues?

1693