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 / abhay puranik
Create a query,drag the Country column,Drag data item from
the tool,name this as Group,Now in the expression
corresponding to this data item,write if(geography contains
('','','') then 'Group1' elseif(Country contains('','',''))
then 'Group2'......And use this query for the query
property of value prompt and use Group as column diplayed
under value prompt.Now,in filter for the main page use if
(Group='Group1') then (Country in ('','','')) else
if.....save report and run.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Name the types of report?
What do you understand by the term 'aggregate cache'?
What are the types of catalogs in cognos?
What are the types of hierarchies?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What are the types of studio present in Cognos?
What is defined as catalog and types of catalogs in Cognos?
what is requery in cognos?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
How can we Maintain the Cube Security by Category level and Dimension level ?
What do you understand by ‘ibm predictive maintenance and quality’?
How to create a cube in Transformer? What is the process? Please mention process thank u
How can you link a query to a data container manually in Report Studio?
How do we convert from Numeric to be Words?
Explain the difference between powerplay transformer and power play reports?