Cognos Report Studio and Framework manager Questions:

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?

37.   Branching and merging projects

38.   Segmented and linked projects

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?