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
- 7757 Views
- I also Faced
- E-Mail Answers
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
What is set to be Cognos configuration?
What is defined as Query studio?
Explain about scorecarding?
What do you understand by the term 'model durability'?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
How do you call a store procedure within a transformation?
What are shortcuts? Where it can be used? What are the advantages?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What are various types of gateways in cognos?
Explain is there any comparison available for cognos reportnet vs crystal reports?
what is degenerate key in oracle ?whare do we use it?
What do you understand by ‘ibm predictive maintenance and quality’?
What are all the types of report?
can we insert all types of charts in a list report? what r the realtime prompts?
how to perform back drill through in cognos 8 what is the use of it
