COGNOS INTERVIEW QUESTIONS AND ANSWERS :
1) can you tell me query subject in cognos8?
Ans) A query subject is thebuilding block of framework manager in cognos. A query subject is a set of query items that have an relationship between them.
2 )What are use of cognos?
1)Scorecarding
2)Planning
3)Analysis
4)Forecasting
3) tell me about materialized view?
A materialized view which is physically stored in a database. Materialized views can improve query speed to be enhanced by pre calculation operations.
4) What types of framework manager?
2 types of framework manager are :
Physical layer
Presentation layer
5)What are main important themes in a data warehouse?
Drilling Down
Drilling Across
Handling Time
6) Where is security module used in cognos8?
Ans) cognos access manager we use security module
7) How do we create reports on cognos ?
Query Studio: create simple and adhoc reports.
Report Studio: create advanced Business Reports
Analysis Studio: create reports from Cube and multi dimensional modeling relational package for analysis purpose.
8) What are folder in cognos ?
Ans) 1)Query Studio
1) can you tell me query subject in cognos8?
Ans) A query subject is thebuilding block of framework manager in cognos. A query subject is a set of query items that have an relationship between them.
2 )What are use of cognos?
1)Scorecarding
2)Planning
3)Analysis
4)Forecasting
3) tell me about materialized view?
A materialized view which is physically stored in a database. Materialized views can improve query speed to be enhanced by pre calculation operations.
2 types of framework manager are :
Physical layer
Presentation layer
5)What are main important themes in a data warehouse?
Drilling Down
Drilling Across
Handling Time
6) Where is security module used in cognos8?
Ans) cognos access manager we use security module
7) How do we create reports on cognos ?
Query Studio: create simple and adhoc reports.
Report Studio: create advanced Business Reports
Analysis Studio: create reports from Cube and multi dimensional modeling relational package for analysis purpose.
8) What are folder in cognos ?
Ans) 1)Query Studio
2)Metrics Studio
3)Analysis Studio
4)Report Studio
5)Event Studio
9) tell about cognos 10 ?
Ans ) Cognos 10 is a powerful suite of products, which focuses on the transformation of raw data into powerful information for business decisions. Cognos 10 can be used at all levels in an organization, users looking for predefined reports to analysts, the requirements of complex data.
10 ) What are the types of roles cognos ?
Ans )Administrators
Consumers
Authors
Developers
11) What are all the different types of prompt in Cognos?
Time prompt
Value prompt
Text Prompt
Date prompt
Date and time prompt
12) What types of report in cognos ?
Cross report
Repeater report
Blank report
List report
Chart report
13) What is Cardinality in tables?
Ans) 1 to 1
1 to m
M to M
M to 1
14)What are the diffrent phases in the Cognos8 Workflow?
Ans )Planing, Manageing, Modeling, Authoring, Consumeing.
15) What is cube size in real time?
Ans 3.0 its depends on projects
11) What are all the different types of prompt in Cognos?
Time prompt
Value prompt
Text Prompt
Date prompt
Date and time prompt
12) What types of report in cognos ?
Cross report
Repeater report
Blank report
List report
Chart report
13) What is Cardinality in tables?
Ans) 1 to 1
1 to m
M to M
M to 1
14)What are the diffrent phases in the Cognos8 Workflow?
Ans )Planing, Manageing, Modeling, Authoring, Consumeing.
15) What is cube size in real time?
Ans 3.0 its depends on projects
