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
- 7819 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 anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
what is power prompt in cognos ep7series?what is the use of this?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
what are slowly changing dimensions? Why we are used scd?
How to do Performence Tunning in Cognos Reports?
What do you mean by drill across?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
What is a Pivot?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
Can you define dimension?
What are the batches and it’s details?
What is the use of powerplay web viewer in cognos?
how to create measures and dimensions?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
