1. What is called Cognos Reporting tool?
Cognos is an IBM reporting tool which is used for reporting and analysis of various data from different datawarehouse.
2. What is Report item?
Report item is defined as a query item which can be dragged and dropped into a work area
3. What is Bitmap Index?
A bitmap index is used for replacement of list of rowids for each key value. This index is mainly efficient for data warehousing as it has low cardinality and low updates.
4. What is a Folder?
A folder consists of repository objects like sources, targets, transformation and mapping that help to organize data warehouse.What is
5.Cognos Connection?
It is a Web portal for Cognos 8 and a component which interracts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data
6. What are the types of prompt in Cognos?
- Value prompt
- Text Prompt
- Date prompt
- Time prompt
- Date and time prompt
7. How to join multiple db in catalog?
Mutiple database could not be connected in a single catalog. So we use hot file for this purpose.
8. How to generate cubes in cognos?
Power Play Transformer contain dimension, measure, model and cube. We can generate cube different way. Just right click on cube name and build. We can write script in unix. Using that we can generate cube.
9. What is snapshot?
A Snapshot is the copy of data, when we create a snapshot it copies the exact data that’s related to the at particular report, we use snapshot whenever we want to compare reports.(Example: we want to compare this month’s report with previous months).
10.What are the responsibilities of Cognos Administrator?
A Cognos Administrator is assigned with following responsibilities.
1. Installations and configurations in distributed network environment.
2. Creating the Repository (Content Store).
3. Perform back up and recovery of Meta Data.
4. Developing the user Administration.
5. Tuning the servers.
6. Deployment.
11. What are the responsibilities of a Cognos Architect?
An Architect is responsible for designing the interface by fulfilling the user requirements.
Once the interface has been designed it should be rigorously tested before distributing to the end user population.
12. What are the roles of an Application Developer?
Design the reports according to the report requirement templates.
Testing the each report with the following types of tests.
a. Unit Testing
b. System Testing
c. Performance Testing
13.What is the information present in the Cognos configuration file?
The configuration file of Cognos is the normal configuration file that includes Cognos Dispatcher and IBM Cognos Report Server processes that is allocated to give it to the processor for faster processing of the resources. The configuration file consists of three to four low affinity threads and one high affinity thread. The threads are managed by using the traffic, which an application can handle. Affinity represents the report service that is provided to the original client from whom the request has come and there can be multiple interactions allowed to satisfy the request. High affinity connections are provided to process the requests from the service report.
14. How many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Using a single Model, we can create as many number of cubes we want. By using the dimension views…etc. Regarding the navigation, when we save cubes, these act as separator multidimensional databases. There won’t be any relations. Navigate means opening the cubes separately.
15. What is the difference between drill down and drill through?
Drill down means it will navigate from detail information to summary level information within report. Drill through means it will navigate from summary to detail from report to report.
16. What is Cardinality?
Cardinality is nothing but relation between tables.
One to One
One to Many
Many to Many
Many to One
One to One
One to Many
Many to Many
Many to One
17. What is OLAP?
OLAP stands for On Line Analytical Processing, a series of protocols used mainly for business reporting.
18.What are components of report studio?
Insertable Objects pane
Properties pane
Explorer bar
Report Viewer
Properties pane
Explorer bar
Report Viewer
19. What are the components of Report Net?
Framework Manager
Cognos Connection
Query Studio
Report Studio
20.Can report net supports cubes?
No
No comments:
Post a Comment