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 METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

1 Answers   IBM,


Can you explain a cognos controller?

0 Answers  


write a query to display the departments with no employee?

0 Answers   HCL,


What is a query set?

3 Answers   IBM,


HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

2 Answers   iFlex,


What is difference between drill through and drill down?

5 Answers   IBM,


What is the diff between Drill through reports and Master detail reports?

2 Answers   CSC, TCS,


can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,


hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...

1 Answers   IBM,


I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,


Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??

2 Answers   Barclays,


---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers   Bank Of America,


Categories