Cognos – Useful Resources

Cognos – Useful Resources ”; Previous Next The following resources contain additional information on Cognos. Please use them to get more in-depth knowledge on this. Python Programming Certification 2024 Most Popular  9 Courses     1 eBooks Tutorialspoint More Detail Artificial Intelligence and Machine Learning Certification 2024 Most Popular  7 Courses     1 eBooks Tutorialspoint More Detail Java Certification 2024 Best Seller  7 Courses     1 eBooks Tutorialspoint More Detail Print Page Previous Next Advertisements ”;

Cognos – Custom Calculations

Cognos – Custom Calculations ”; Previous Next You can add custom calculations to your report as per the business requirement. With the help of operators, different calculations can be added like if you want to add a new value salary*0.2 as a Bonus. To create Calculations in a Report − Select the item in the report. Click the insert calculation button and select the calculation to perform. Note − Calculations that are not applicable to the items you selected are greyed out. To change the order of the operands or the name of the calculated item added to the report, click Custom. The calculation appears as a new row or a column in your report. Drilling Drill up and drill down is used to perform analysis by moving between levels of information. Drill down is used to see more detailed information to lowest level and drill up is used to compare the results. To drill down or up in a single row or column, pause the pointer over the label text until the icon with the plus sign (+) and caret drill down drill up icon appears and the text is underlined, and then click. To drill down or up in both a row and column simultaneously, click on the value at the intersection of the row and the column, and then click again. Print Page Previous Next Advertisements ”;

Cognos – Save an Analysis

Cognos – Save an Analysis ”; Previous Next To save an analysis, you can click on the save button at the top as shown in the following screenshot. Enter a name of the analysis and location → then click OK. Print Page Previous Next Advertisements ”;

Cognos – Report Templates

Cognos – Report Templates ”; Previous Next In Report Studio, you can create different types of reports. They allow you to present the data in different formats like a list report can be used to show the customer information. The following reports can be created in Report Studio − List Report This report is used to show the data in detailed format. Data is shown in rows and columns and each column contains all the values of a data item. Quarter Order number Quantity Revenue Q4 101035 105 $4,200.00 101037 90 $8,470.80 101044 124 $11,479.92 101052 193 $15,952.42 101064 58 $5,458.96 101065 78 $7,341.36 101081 145 $5,800.00 101092 81 $7,623.72 101093 50 $4,706.00 101103 139 $5,560.00 Crosstab Like list report, a cross tab report also shows the data in row and columns, but the data is compact and not detailed. At the intersection points of rows and columns, you show the summarized data. Chart You can use the Report Studio to create many chart types, including column, bar, area, and line charts. You can also create custom charts that combine these chart types. Map You can also use maps in the Report Studio to present data for a particular region, country or a location. A map report consists of three parts − Region Layer Point Layer Display Layer Repeater Repeaters are used to add repeat items in a report while running the report. To add a Repeater, drag a repeater from the tool box to work area. Print Page Previous Next Advertisements ”;

Cognos – Filters

Cognos – Filters ”; Previous Next Filters are used to limit the data that you want in your report. You can apply one or more filters in a Cognos report and the report returns the data that meet the filter conditions. You can create various custom filters in a report as per the requirement. Select the column to filter by. Click the drop down list from the Filter button. Choose Create Custom Filter. The Filter Condition dialog displays. In the next window, define the filter’s parameters. Condition − click the list arrow to see your choices (Show or Don’t show the following values). Values − click the list arrow to see your choices. Keywords − allows you to search for specific values within the values list. Values List − shows the field values which you can use as filter values. You can select one or many. Use the arrow button to add multiple values. Select a value and click the right pointing arrow to move the value into the selected column. You can use the Ctrl key to add multiple values at tone time. Click OK when the filter is defined. Note − You can view filters in the Query Explorer page and not the page explorer. You can go to the query explorer and view the filters. Deleting a Filter A filter can be deleted by using the following steps − Go to the Query Explorer as shown in the above screenshot Click on Query and Locate the Detail Filters pane in the upper right side of the window as shown in above screenshot Select the filter that you want to delete and press the delete button You can also cut/copy a filter Print Page Previous Next Advertisements ”;

Cognos – Ad-hoc Reports

Cognos – Ad-hoc Reports ”; Previous Next Using ad-hoc reporting, a user can create queries or reports for ad-hoc analysis. Ad-hoc reporting feature allows business users to create simple queries and reports on the top of fact and dimension table in data Warehouse. The Query Studio in Cognos BI, provides the following features − View data and perform ad-hoc data analysis. Save the report for future use. Work with data in the report by applying filters, summaries and calculations. To create ad-hoc report using query studio, login to IBM Cognos software and click on Query my data. Select the report package. Next time you visit this page; you will see your selection under the recently used packages. Click on the package name. In the next screen, you can add Dimension elements, filters and prompts, facts and calculation, etc. You should insert the objects in this order. To insert object in the report, you can use Insert button at the bottom. Insert and filter dimension elements Insert filters and prompts Insert facts and calculations Apply finishing touches Save, run, collaborate, and share At the top, you have the tool bar, where you can create a new report, save existing report, cut, paste, insert charts, drill up and down, etc. When you insert all the objects to a report, you can click on the Run option () at the top. Print Page Previous Next Advertisements ”;

Cognos – Connections

Cognos – Connections ”; Previous Next You can report interactive user reports in Cognos Studio on the top of various data sources by creating relational and OLAP connections in web administration interface which are later used for data modeling in Framework Manager known as packages. All the reports and dashboards that are created in Cognos Studio they are published to Cognos Connection and portal for distribution. The report studio can be used to run the complex report and to view the Business Intelligence information or this can also be accessed from different portals where they are published. Cognos Connections are used to access reports, queries, analysis, and packages. They can also be used to create report shortcuts, URLs and pages and to organize entries and they can also be customized for other use. Connecting Different Data Sources A data source defines the physical connection to a database and different connection parameters like connection time out, location of database, etc. A data source connection contains credential and sign on information. You can create a new database connection or can also edit an existing data source connection. You can also combine one or more data source connections and create packages and published them using Framework manager. Dynamic Query Mode The dynamic query mode is used to provide communication to data source using XMLA/Java connections. To connect to the Relation database, you can use type4 JDBC connection which converts JDBC calls into vendor specific format. It provides improved performance over type 2 drivers because there is no need to convert calls to ODBC or database API. Dynamic query mode in Cognos connection can support the following types of Relational databases − Microsoft SQL Server Oracle IBM DB2 Teradata Netezza To support OLAP data sources, Java/XMLA connectivity provides optimized and enhanced MDX for different OLAP versions and technology. The Dynamic query mode in Cognos can be used with the following OLAP data sources − SAP Business Information Warehouse (SAP BW) Oracle Essbase Microsoft Analysis Services IBM Cognos TM1 IBM Cognos Real-time Monitoring DB2 Data Sources The DB2 connection type are used to connect to DB2 Windows, Unix and Linux, Db2 zOS, etc. The common connection parameters used in DB2 data source includes − Database Name Timeouts Signon DB2 connect string Collation Sequence Creating a Data Source Connection in IBM Cognos To create models in IBM Cognos Framework Manager, there is a need to create a data source connection. When defining the data source connection, you need to enter the connection parameters – location of database, timeout interval, Sign-on, etc. In IBM Cognos Connection → click on the Launch IBM Cognos Administration In the Configuration tab, click Data Source Connections. In this window, navigate to the New Data Source button. Enter the unique connection name and description. You can add a description related to the data source to uniquely identify the connection and click the next button. Select the type of connection from the drop down list and click on the next button as shown in the following screenshot. In the next screen that appears, enter the connection details as shown in the following screenshot. You can use the Test connection to test the connectivity to the data source using connection parameters that you have defined. Click on the finish button once done. Data Source Security Setup Data Source Security can be defined using IBM Cognos authentication. As per the data source, different types of authentication can be configured in the Cognos connection − No Authentication − This allows login to the data source without using any sign-on credentials. This type of connection doesn’t provide data source security in connection. IBM Cognos Software Service Credential − In this type of a sign-on, you log in to the data source using a logon specified for the IBM Cognos Service and the user does not require a separate database sign-on. In a live environment, it is advisable to use individual database sign on. External Name Space − It requires the same BI logon credentials that are used to authenticate the external authentication namespace. The user must be logged into the name space before logging in to the data source and it should be active. All the data sources also support data source sign-on defined for everyone in the group or for individual users, group or roles. If the data source requires a data source sign-on, but you don”t have the access to a sign-on for this data source, you will be prompted to log on each time you access the data source. IBM Cognos also supports security at cube level. If you are using cubes, security may be set at the cube level. For Microsoft Analysis Service, security is defined at the cube level roles. Print Page Previous Next Advertisements ”;

Cognos – Report Types

Cognos – Report Types ”; Previous Next You can use different report types in the Cognos Query Studio to meet the business requirements. You can create the following report types in the Query Studio − List Reports − These reports are used to show your entire customer base as shown in the following screenshot. Crosstab Reports − These are used to show quantity sold with product and region on different axis. Charts − You can insert charts to show data graphically. You can combine a chart with a Crosstab or also with a list report. Print Page Previous Next Advertisements ”;

Cognos – Query Studio

Cognos – Query Studio ”; Previous Next Query Studio is defined as a web based tool for creating queries and reports in Cognos 8. It is also used to run simple queries and reports as well. In Query Studio, the following functions can be performed − Viewing Data − Using Query Studio, you can connect to data source to view the data in a tree hierarchy. You can see query subject, query item details, etc. Creating BI Reports − You can use Query studio to create simple reports by using the data source. You can also refer existing reports to create a new report. Changing Existing Reports − You can also change existing reports by editing report layout – Add charts, titles, headings, border styles, etc. Data Customization in Report − You can apply various customizations in reports- Filters, Calculations and aggregations to perform data analysis, drill up and drill down, etc. Print Page Previous Next Advertisements ”;

Cognos – List Report

Cognos – List Report ”; Previous Next A list report that shows the data in rows and columns and each cell shows the data in the database or you can also add custom calculations in a list report. To create a new list report, go to New → Blank as shown in the following screenshot. When you select a list report, you get the following structure of the report in the Report Studio. You have to drag the objects from the package on the left side to the report structure. You can also edit the title of the report that will appear once you run the report. You can use different tools at the top for the report formatting. To save a report, click on the save button. To run a report, click on Run report. Once you save the report, you have an option to save it in the Public folder or My folder. When you click on the Run option, you can select different formats to run the report. Print Page Previous Next Advertisements ”;