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
- 7871 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhanu
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)
u can add more static values if u want.
in report query put filter
write a if statement or case
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)
case when ?country? =1
then query.country in (us,uk)
when ?country?=2
then query.country in(INDIA,srilanka)
end
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can you explain dynamic query mode?
what is the difference between querystudio in reportnet and cognos8
What you mean by drill across and what is the difference between drill through, drill across?
What are the advantages of using cognos sql?
----------------------What are the User Securities?
What is the function of cognos dispatcher?
Can you define materialized view?
faq's on cognos
What is set to be cardinality?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
which type of project we r going to snowflake schema
What are all types of Batches?
Explain the different types of views used in cognos.
What is the difference between a data mart and a data warehouse?
what is a prompt value in report studio and variables ?
