i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt

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 / kranthi

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

Answers were Sorted based on User's Feedback

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / itesh

simple man ,
create country prompt with 2 dynamic prompt value dispay
value WESTERN_COUNTRIES>use vale (1)ASIAN_COUNTRIES (2)

in report query put filter

write a if statement
if (?country?)=1
then country in (USA,UK)
else country in (INDIA, CHINA)

cheers

Is This Answer Correct ?

9 Yes

3 No

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / 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

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / beckham

Use a customized data item in a query.this query is the
source query for the region prompt.Make sure the customized
data item is used in main query and filterd accordingly.

Is This Answer Correct ?

4 Yes

5 No

i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control l..

Answer / vishnu

Use Cascading Prompt

Is This Answer Correct ?

2 Yes

9 No

Post New Answer

More Cognos Interview Questions

---------------Describe OLAP Reporting and RDBMS Reporting?

0 Answers Bank Of America,

This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,

0 Answers

Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...

1 Answers

How to Improve the Performance of the Report? i need this urgently .

4 Answers HSBC,

What are all the types of report?

0 Answers

What are shortcuts? Where it can be used? What are the advantages?

0 Answers

Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!

5 Answers HCL, Wipro,

i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

1 Answers TCS,

What is metric studio?what is score cards and how to implement score cards what is the use of score card?

1 Answers IBM,

Can you define cognos impromptu?

0 Answers

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

1 Answers Satyam, TCS,

How to apply securities for reports in cognos connection?

0 Answers TCS,

For more Cognos Interview Questions Click Here