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
- 8019 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
Can you define set to be cardinality?
How can I test reports in cagonos?
What are initial page components of Cognos connection?
Why cognos scenario is used?
What are the roles defined by cognos platform?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What are the message flows?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is the size of database for you project? 4. How many dimensions did you use in your reports?
Define olap designer? What is the difference between the content store and content manager? What is the difference between drill through, drill across? How create measures and dimensions? what are the components in the cognos connection page
consists (eg: my folder, public folder,directions, schedule
management tool etc.....)
