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 advantage of using shortcuts?

0 Answers  


Can u please describe the different types of traps with eg. Thanks

2 Answers  


How to do deployment?

5 Answers  


Please explain the different stages in creating a report in cognos report net?

0 Answers  


After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?

1 Answers  






How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 Answers  


-----------Diff b/w OLAP and RDBMS?

0 Answers   Bank Of America,


What is model filter?

0 Answers  


Explain what is the main advantage of impromptu over cognos reportnet?

0 Answers  


what is exact catalog size?

4 Answers   IBM,


What is difference between informatica power mart and power center?

0 Answers  


What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.

1 Answers  


Categories