Interested to Buy Any Domain ? << Click Here >> for more details...
suppose there are 15 countries like (US, UK,
ENGLAND,INDIA,JAPAN.......)i want a value prompt in the
report and this value prompt should contain groups like
group1(US,UK,ENG), group2(INDIA,US,UK), group3
(ENG,JAPAN,INDIA)and in the value prompt the values should
be group1,group2,group3 how can we do this?
- 4 Answers
- 7815 Views
- I also Faced
- E-Mail Answers
Answer Posted / balanandam
Abhay ur concept is write, but there is other way to implement this ....
using static choice property in the properties pan u can put the values like Group1, Group2....
and modify the default sql as
if query.country in (?parameter?='Group1')then (Country in ('','','')) else
else if.....then...
else if....then...
else query.country='parameter';
i think this will clear more
save report and run.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
Can you define a catalog and types of catalogs in cognos?
What is the use of report studio?
----------------Diff b/w Dimensional modeling and Relational modeling?
---------------Tell me about DWH Concepts?
how you migrate reports to cognos 8 from previous versions?
what is the difference between querystudio in reportnet and cognos8
What do you understand by the term 'aggregate advisor?'
What are the two types of framework manager?
what is the procedure for scheduling conditional rendering?
What is meant by drill down?
Which lifecycle we will use for reporting?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
Define query studio?
What is the difference between group and associare?
