i have 4 countries in my database as USA, UK, INDIA, CHANA.
In value prompt's prompt control list, i want
WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country
names.
When i click on WESTERN_COUNTRIES, it should retrieve USA,
UK records and when i click on ASIAN_COUNTRIES, it should
retrieve INDIA, CHINA records.
How is it possible?
Answer Posted / beckham
Use a customized data item in a query.this query is the
source query for the region prompt.Make sure the customized
data item is used in main query and filterd accordingly.
| Is This Answer Correct ? | 4 Yes | 5 No |
Post New Answer View All Answers
Can you define report item?
how you create security to reports?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What is defined as Query studio?
How do we drill through from a powerplay cube to reportnet?\
how u will determine the performence tune will occur either in report or system
Can you define framework manager?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
-----------With out using DrillThrough how to do Reports?
What junk dimension contains?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Can you define metrics designer?
What are the considerations regarding performance kept in mind while setting up cognos?
write a query to display the departments with no employee?