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 |
How many types of models are present in cognos.?
What is the use of 'individual data source' option while using filter in query studio?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
What is drill down and slicing and dicing whats the difference between them?
What is namespace and what it holds?
What is the difference between Conditional Layout and Conditional Block
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,
What is called Cognos powerplay?
What are user classes?
Can you define framework manager?
What is the use of Cognos scenario?