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

I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?

2 Answers   IBM,


1)How to bursting the cross tab report? 2)What is meant by Object explorer? 3)What is cascade report?

1 Answers   IBM,


hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........

1 Answers   TCS,


hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  


how u create cubes in ur project

2 Answers   IBM,






What is difference between page break and section report? What is main advantage datawarehousing over oracle?

0 Answers  


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

7 Answers   HCL,


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

0 Answers  


I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

0 Answers  


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  


What are the types of hierarchies?

0 Answers  


What is a query set?

3 Answers   IBM,


Categories