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
- 6789 Views
- I also Faced
- E-Mail Answers
Answer Posted / poorna chandra reddy
Create a data item and in that writ condition like below
if(country in (' US,UK,ENG' , ' INDIA,US,UK'))
then ('Group1')
else if (country in (‘INDIA’,’US’,’UK’)
then ('Group2')
else ('Group3')
Then create value prompt and assign this data item to the
value prompt.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
how you provide security to reports? How you provide security to packages ?
What is meant by junk dimension?
What are the types of studio present in Cognos?
What are the different types of important services used in cognos?
What are the advantages of shortcuts?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
what is stitch query in reportnet?
What do you understand by ‘ibm predictive maintenance and quality’?
What you mean by drill across?
What are the components used in web tier?
What are all the different types of prompt in cognos?
---------------Tell me about DWH Concepts?
How create measures and dimensions?
What are all types of Batches?
