Just add static choices to value parameter as WESTERN_COUNTRIES, ASIAN

i have 4 countries in my database as USA, UK, INDIA, CHANA.
In value prompt's prompt control list, i want
WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country
names.
When i click on WESTERN_COUNTRIES, it should retrieve USA,
UK records and when i click on ASIAN_COUNTRIES, it should
retrieve INDIA, CHINA records.
How is it possible?

Question Posted / gajendra kumar

4 Answers
10204 Views
Tech Mahindra, I also Faced
E-Mail Answers

Answer Posted / gajendra kumar

Just add static choices to value parameter as WESTERN_COUNTRIES, ASIAN_COUNTRIES. In report query add the filter (?parameter? = 'WESTERN_COUNTRIES' and [Dataitem] in ('USA', 'UK'))
or
(?parameter? = 'ASIAN_COUNTRIES' and [Dataitem] in ('INDIA', 'CHINA'))

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

faq's on cognos

4098

Can you define dimension?

1134

how to create cubes in transformer ?

1119

What is model filter?

1318

What do you mean by Drill down and Drill Up?

1052

how to create measures and dimensions?

1174

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!

2053

What r the names of the reports that you prepared?

1018

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2048

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2371

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1192

how to explain health care project and which reports we can create in health care doain?

6846

-----------Diff b/w OLAP and RDBMS?

2109

Define query studio?

1046

How do we drill through from a powerplay cube to reportnet?\

2401