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 do you mean by drill across?

1 Answers  


11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  


how many types of variables in cognos report net and cognos 8

4 Answers   HCL, Merrill Lynch,


How can I change reports to another package???

3 Answers   IBM,


I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?

2 Answers  


plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........

1 Answers  


what is an sid (surrogate key)?

4 Answers   IBM,


What is Stich Query in Reportnet?

10 Answers  


can you apply grouping on crosstab?

1 Answers   CTS,


I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 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  


Hi, I am Searching on Cognos 8, I don't know how to explain the projects in cognos.Can anybody help me in this regard. My email id is hchereddy@gmail.com. Thanks in advance

0 Answers   IBM,


Categories