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 / balanandam
Abhay ur concept is write, but there is other way to implement this ....
using static choice property in the properties pan u can put the values like Group1, Group2....
and modify the default sql as
if query.country in (?parameter?='Group1')then (Country in ('','','')) else
else if.....then...
else if....then...
else query.country='parameter';
i think this will clear more
save report and run.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Define query studio?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
how can I test reports in cagnos?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate 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 What are the advantages of using cognos sql? Actually we have 500 users when they run the report display
the flage image related country user? How its possible? hi all i am searching for cognos jobs pls inform about the
jobs to:santosh.koora@gmail.com What is the difference between a cascading report and drill through the report? How Metrics Studio is better than Report Studio? how can you get the errors in job? when loops are araised
we get error? Name the types of gateway? Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me. in u r data u having duplicates how to fetch the latest
data in our report? Why need staging area database for dwh?