I have four region(Us, Uk, Canada, Europe) in my value
prompt. Along with this I want new prompt called All. Once
I click on All it should display all regions data. How can
I achieve this ?
Answer Posted / cognosvij
Hi Sriprabhath,
In your value prompt add the static chioce as 'All'
and in filter put the expression as....
(region column in (?Parameter1?)) or (?Parameter1?='All')
hope this may help u :)
vij
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What are the considerations regarding performance kept in mind while setting up cognos?
What do you mean by drill through report?
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
Why need staging area database for dwh?
what is the difference between filter and condition?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
How security is concerned with Reportnet? Explain its implementing steps.
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Can you explain a cognos controller?
how to explain health care project and which reports we can create in health care doain?
What you mean by drill across and what is the difference between drill through, drill across?
Can you define transformer?
what are the dimensions that you have in your current project?list them?
What is a Transformer?
What is cognos powerhouse?