COGNOS REPORT STUDIO INTERVIEW QUESTIONS ANSWERS PDF

The Cognos reports contain the statuses and trending data reports about the Tivoli Storage Manager Server and its clients. Custom Cognos reports can be created by inserting the items from the data source into an empty report. Any existing Cognos report can be opened and viewed by modifying it or using it as the base of a new customized report. What are the gateways used in Cognos?

Author:Yolabar Vokasa
Country:Sao Tome and Principe
Language:English (Spanish)
Genre:Career
Published (Last):8 January 2008
Pages:41
PDF File Size:20.25 Mb
ePub File Size:16.55 Mb
ISBN:972-7-17024-699-8
Downloads:92192
Price:Free* [*Free Regsitration Required]
Uploader:Zololmaran



The Cognos reports contain the statuses and trending data reports about the Tivoli Storage Manager Server and its clients. Custom Cognos reports can be created by inserting the items from the data source into an empty report.

Any existing Cognos report can be opened and viewed by modifying it or using it as the base of a new customized report. What are the gateways used in Cognos? Servlet is the best gateway for the application servers those support servlets. Apache mod is the gateway supported by the Apache Servers like Tomcat. When a request is received by the IBM Cognos BI gateway server, it encrypts the passwords to always ensure the security.

It also attaches the environment variables into the Web server and also adds a default namespace to the request in order to ensure that the server always authenticates the current user in the correct namespace directory. What is a Query Studio in Cognos? In Query Studio, we can view data, create reports, change the appearance of reports and work with data in a report. The data can be viewed by connecting to a data source and viewing the data in a hierarchical tree by expanding the query subjects to check the details of the query item.

The reports can be created by using the data source, which can be saved and reused. A new report can also be created by opening an existing report and changing it by saving it using a different name. The appearance of the reports can be changed by improving the layout of the reports.

For example, a chart can be created by adding a title and specifying a text and border styles , or by reordering the columns for an easy comparison of data. The data in a report can be worked out by using filters, summaries, and calculations by comparing and analyzing the data and drilling up and drilling down the data to view the related information. What are the advantages of the Cognos tool?

Answer: The advantages of IBM Cognos tools are such as it reduces the maintenance cost due to its complete report coverage and less footprint environment. The results provided are faster in shortening the reports due to its integration and adaptive authoring.

Familiar business terms cause this to be more adaptive and able to work. Able to use different types of data representation such as a bar or 3D bar, pie or doughnut, crosstabs, gauge, line, scatter, funnel, waterfall and dot density features. Complex and multiple page creation capabilities using multiple data sources. Also, the features include deploying applications, designing reports and doing comparative analysis. The business models can be transformed into a reactive model by identifying the possible risks and outcomes by making a thorough analysis by the use of predictive tools.

Recommended Article This has been a comprehensive guide to the Cognos Interview Questions and answers so that the candidate can crackdown these Cognos Interview Questions easily. You may also look at the following articles to learn more —.

HESABDARI SANATI PDF

Cognos Bi Report Studio Interview Questions & Answers

What do you mean by drill across? The drill across executes queries with the help of more than one cube. What are all the types of hierarchies? There are two types of hierarchies: Attribute hierarchies User defined hierarchies What is the use of Cognos decision stream?

HEINZ UNBEHAUEN REGELUNGSTECHNIK 1 PDF

Most important Cognos Interview Questions and Answers

Explain about Aggregate Advisor? Ans: Aggregate Advisor is a performance optimization utility Part of the Dynamic Query Analyzer Suggest database aggregate tables, in-memory aggregate, or both. After a cube is restarted, the aggregates execute the necessary SQL statements to retrieve the summarized values and place the values in its aggregate cache for subsequent use during query processing. Run during off-peak, non-critical business hours

SIX ATTITUDES FOR WINNERS NORMAN VINCENT PEALE PDF

Cognos Interview Questions And Answers

Q31 What are all types of Batches in Cognos? Cascading report means extracting data from one prompt using the values of another prompt. Drill through report means extracting data by selecting a column in a report. It means getting the detailed information by clicking that column data. Q33 How is Standard different from Metrics folder? It is yellow in color and acts as a local computer folder.

IZOTOPE ALLOY 2 MANUAL PDF

Top Cognos Interview Questions And Answers

What is Cognos Reporting tool? Cognos is a Reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse. What is Cognos Connection? It is a Web portal for Cognos 8 and a component which interracts with the Content Store. What is Report item?

Related Articles