How to select all in value prompt instead of cascade prompt?

Answers were Sorted based on User's Feedback



How to select all in value prompt instead of cascade prompt?..

Answer / laxmi

For the value prompt add "All" as static choice
Then go to Detail filter and add the below condition

for ex: Producline= ?paramter1? or 'All' in ?parameter?

Then you can select individual vlaue in value prompt or all
the values while click on "All"

Is This Answer Correct ?    3 Yes 0 No

How to select all in value prompt instead of cascade prompt?..

Answer / lakshmi reddy

writing the filter condition

first select value prompt in properties pane add all to the
static choice

in filter condition add extra condition using and operator


----------and ?parameter1?='all'

Is This Answer Correct ?    2 Yes 0 No

How to select all in value prompt instead of cascade prompt?..

Answer / l m patel

For the value prompt add "All" as static choice
Then go to Detail filter and add the below condition

for ex: Producline= ?paramter1? or 'All' in ?parameter?

Then you can select individual vlaue in value prompt or all
the values while click on "All"

But if you asking instead of cacading value then answer is
wrong bez cascading and passing 'all' these are two
different thing.
Cascading nothing but filter prompt[Value] depending on
previous prompt.
EX : if site select then show all location according to the
select site.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  


How can we find out cardinality between two tables?

3 Answers   IBM,


What errors and types of errors you faced in Cognos ReportNet?

1 Answers  


Can we install cognos on windows 7?

4 Answers  


cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  






i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

0 Answers  


Can you define cognos powerplay?

0 Answers  


what is slowly growing dimension??

6 Answers   Accenture,


how u create security to reports ????

10 Answers   iFlex, iGate,


write a query to display to 10 max record from the employee table?

2 Answers   HCL,


What is the use of cognos decision stream?

0 Answers  


what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.

0 Answers   Magna Infotech,


Categories