How to select all in value prompt instead of cascade prompt?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
Can you explain a cognos controller?
write a query to display the departments with no employee?
What is a query set?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
What is difference between drill through and drill down?
What is the diff between Drill through reports and Master detail reports?
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
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...
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
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
---------------Describe OLAP Reporting and RDBMS Reporting?