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 / 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
What is catalog and types of catalogs in cagonos and which is better?
-------------What is Coditional Prompting?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
What are cognos connection initial page components?
What are all the advantages of Cognos?
Define metrics studio?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
Define the slice and dice?
What is a Framework manager?
What are all the components of Report Studio?
Why cognos scenario is used?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is difference between content store and content manager?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?