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
What is a Pivot?
How to select multiple values from type-in prompt?
What is a Folder?
What are the different types of important services used in cognos?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
write a query to display the departments with no employee?
what is the difference between native sql and cognos sql?
Can you define query studio?
What is called cognos reporting tool?
Give me any example of semi and non additive measures?
Which lifecycle we will use for reporting?
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.
Name the types of report?
What do you understand by the cognos?
What is difference between page break and section report?