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?
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
Why cognos decision stream is used?
Explain the characteristics of cognos?
What are the ways to import data into catalog?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
---------------Tell me about DWH Concepts?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Can you define materialized view?
New coloums are added in database, then how you know in report level
When we save a report in report studio with what extn it save?
What is an olap designer?
Can you define pivot?
how to perform back drill through in cognos 8 what is the use of it
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Why cognos scenario is used?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?