Cognos Data Warehouse Interview Questions

 
1.
How can we create a dynamic column name in Cognos?
2.
What is Cognos Powerhouse and what is it used for?
3.
What is the difference b/w macros and prompt?
4.
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? is it possible, if so how?
5.
What is meant by Junk Dimension?
6.
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?
7.
How to crate cubes in transformer?
8.
What is catalog and types of catalogs in cagonos and which is better?
9.
What Junk Dimension contains?
10.
Please explain the different stages in creating a report in cognos report net?
11.
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
12.
What is drill down and slicing and dicing whats the difference between them?
13.
Give me any example of semi and non additive measures?
14.
What is difference between PAGE BREAK and Section Report?

What is Main Advantage Datawarehousing over Oracle?
15.
What is Zero-foot print?
What are the other methods working as deployment functionality?
16.
How you drill from powerPLay to Impromptu? Explain all Steps?
17.
What is the difference between enterprise data warehouse and data warehouse?
18.
what is meant by alternate drill down with ex?
19.
How create measures and Demensions?
20.
What is loop in frameworkmanager?
21.
What you mean by Drill across and what is the difference between drill through, drill across?
22.
How do add dynamic titles in PP?
23.
What is the difference between group and associare?
24.
What is Cognos Visualizer and Cognos Scripting?
25.
How can create users and permissions in cognos?
26.
How can i schedule reports in cognos?
27.
How can i test reports in cagonos?
28.
What are products of cognos?
29.
How can we create a dynamic column name in Cognos?
30.
What is Cognos Powerhouse and what is it used for?
31.
What is the difference b/w macros and prompt?
32.
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? is it possible, if so how?
33.
What is meant by Junk Dimension?
34.
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?
35.
How to crate cubes in transformer?
36.
What is catalog and types of catalogs in cagonos and which is better?
37.
What Junk Dimension contains?
38.
Please explain the different stages in creating a report in cognos report net?
39.
What is the difference between a cascading report and drillthru report?why do we go for drill thru report?
40.
What is drill down and slicing and dicing whats the difference between them?
41.
Give me any example of semi and non additive measures?
42.
What is difference between PAGE BREAK and Section Report?

What is Main Advantage Datawarehousing over Oracle?
43.
What is Zero-foot print?
What are the other methods working as deployment functionality?
44.
How you drill from powerPLay to Impromptu? Explain all Steps?
45.
What is the difference between enterprise data warehouse and data warehouse?
46.
what is meant by alternate drill down with ex?
47.
How create measures and Demensions?
48.
What is loop in frameworkmanager?
49.
What you mean by Drill across and what is the difference between drill through, drill across?
50.
How do add dynamic titles in PP?
51.
What is the difference between group and associare?
52.
What is Cognos Visualizer and Cognos Scripting?
53.
How can create users and permissions in cognos?
54.
How can i schedule reports in cognos?
55.
How can i test reports in cagonos?
56.
What are products of cognos?