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
- 7767 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
-------------How you design DWH?
Can you explain the advantage of using shortcuts?
in u r data u having duplicates how to fetch the latest data in our report?
how u will design the report if the objects are available
What is the difference between a cascading report and drill through report?
How can I schedule reports in cognos?
How is cognos model organization works?
How do you improve the performance of the Cognos Analytics report
What is called Cognos powerplay?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What is Fullouterjoin?
What is Additive function?
how to test reports in cognos?
What is set to be cardinality?
What are all the types of gateway used in Cognos?
