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
- 7820 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
How can I test reports in cagonos?
What is the difference between the standard and metrics folder?
What is the difference between set functions and filter function in dimensional data?
what is a prompt value in report studio and variables ?
What is a Datastore in Cognos?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is Bitmap Index?
what is the difference between querystudio in reportnet and cognos8
What is called materialized view?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
What is meant by alternate drill down with ex?
How to test a cube?
What is the difference b/w macros and prompt?
what do u mean by bridge group? where we r using this one?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
