Cognos Data Warehouse Question:

Download Job Interview Questions and Answers PDF

In my report contain Product name, Amount, Country, Sales person.
I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source.
if u select the Asia in prompt page-ll Asian country results I want in report page.
I discussed with my friends and colleague, they told use the static choice function.
Still I face this problem. if u know please tell me?

Cognos Data Warehouse Interview Question
Cognos Data Warehouse Interview Question

Answer:

Based on country column find out the territory.create territory column in model level. In my expectation we should hard code using case condition.
If u find any best answers please give me solution.

Download Cognos Data Warehouse Interview Questions And Answers PDF

Previous QuestionNext Question
What is meant by Junk Dimension?How to crate cubes in transformer?