1.
Cognos Architecture
2.
Difference between Style variable and Render Variable
3.
Difference between Conditional block and Render
Variable
4.
Types of filters in report studio (Detail filter
and Summary filter)
Detail filter: Before aggregation and After aggregation
Summary filter: footer level calculation
5.
Difference between Detail filter and Summary
filter?
6.
Types of calculation in report studio
7.
Types of prompt? Explain Cascading Prompt
8.
No of rows per page?
9.
Difference between Template and layout component
reference?
10.
Difference between Date Prompt and Value Prompt?
If date prompt going to create the query or not?
11.
Difference between Drill up, Drill down and
Drill through?
12.
Explain the Slicer and Dicer?
13.
What is Bursting
14.
Can you
explain Master detail relationship
15.
Dispatcher setting
16.
Hide/remove fields based on output format
17.
Schedule the report based on the different regions
and different time? (Report Viewer)
18.
Stitched query
19.
What is a Data Warehouse?
20.
What is a Datamart?
21.
Types of facts and types of fact tables?
22.
Confirmed dimension, Degenerated dimension
23.
Slowly changing dimension
24.
Difference between star schema and Snow flake
schema
25.
Explain Business key and member caption
26.
Difference between aggregation and Rollup
aggregation
27.
Cardinality? Types of cardinality? Can you
explain granularity?
28.
Session parameter and Parameter Maps
29.
governor settings in cognos framework manager
30.
Can we do Union, Intersect, and Except in
Framework Manager
31.
How to create scope relationship in framework
manager?
32.
Types of securities in framework manager?
33.
Types of query subjects?
34.
How to call the user defined function in cognos
framework?
35.
Types of sql in cognos
36.
What is a functional set, Model, Namespace, and
Package?
39.
Use of Bridge table?
40.
Types of Traps?
41.
Types of filters in framework manager
42.
Types of calculations in framework manager
43.
What is a macro?
44.
Difference between alias and shortcut?
45.
What is a User Class?
46.
Is it possible to convert crosstab to list?
47.
Types of usage properties?
48.
What is a loop? How to resolve the loop in
framework manager?
49. How to pass value to stored procedure from Report Studio and display value
50. Define the Role Playing dimension?
51. How can we do the Unit Testing?
52. Galaxy schema?
53. Difference between Page Break and PageSet?
54. Difference between Group Span and Level Span?
55. What is Minimized SQL?
56, what is Data Masking?
49. How to pass value to stored procedure from Report Studio and display value
50. Define the Role Playing dimension?
51. How can we do the Unit Testing?
52. Galaxy schema?
53. Difference between Page Break and PageSet?
54. Difference between Group Span and Level Span?
55. What is Minimized SQL?
56, what is Data Masking?
No comments:
Post a Comment