The following diagram explains the Cognos connection

a. Connecting different data sources:

What do you know about data sources? Here we are going to explain the data source definition. A data source specifies any physical connection to the database server and different connection parameters such as database location, connection timeout, and generating the request. Any data source connection consists of credentials and signs in detail. Here user can also create a new database connection, edit an already existing data source connection. Here you can also merge one or more data source connections, create new packages, and publish them with the help of the framework manager.

b. The dynamic query mode:

The dynamic query mode mainly used to offer better communication between different data sources with the help of XMLA/java connections. To connect with any relational database, you can make use of a type4 JDBC connection and these connections convert JDBC calls into a vendor-specific format. This JDBC calls format offers improved type 2 driver connectivity. Due to this reason, there is no need to convert data calls to ODBC (Object database connectivity) or any database API. A dynamic query mode in Cognos supports the following types of relational databases.

1. Microsoft SQL database server

2. Oracle database

3. IBM database 2

4. Teradata system

5. Netezza

To support the OLAP database source, both java and XMLA data connectivity offers enhanced and scalable MDX for various OLAP versions and technology. The Dynamic query mode can also be used with the various OLAP data sources:

a. SAP BI (business information) warehouse

b. Oracle Essbase

c. Microsoft analytical services

d. IBM Cognos TM1

e. IBM Cognos real-time monitoring

DB2 data sources:

In general, the DB2 connection types are used to Connect DB2 windows, UNIX, and Linux, operating system platforms.

The common connection parameters used in DB2 data sources included are

1. Database name

2. Timeouts system

3. Sign on management

4. DB2 connect string

5. Collation sequence management

Data Source Security set up:

Data source security can be specified by using the IBM Cognos authentication environment. As per the data source system, different authentication will be configured in the Cognos connection.

1. No authentication: This connection allows users to login into the data source without using single sign-on credentials. This type of connection will not provide any data source security.

2. IBM Cognos software service is very credential: In this type of single sign-on method, first, you need to log into the data source management to access IBM Cognos service, and here the user does not require a separate database single sign-on system. In any live environment, it’s always good to use individual database sign-on.

3. External namespace: This requires the same business intelligence logon for the credentials to authenticate the external authentication namespace. Here the user must be logged into the IBM Cognos system with the help of namespace before logging into the data source and that should be active.

The following diagram explains this;

Here all the data source system also supports data source single sign-on specification for individual users, groups, and roles. If the data source requires any data source sign-on, then you will be prompted to access each data source. IBM Cognos also offers security at the cube levels.

Subscribe to our YouTube channel to get new updates..!

Cognos packages used:

In this section, we will be explaining how to create Packages in Cognos:

First step:

How to create a package?

In IBM Cognos, users can create packages for SAP business warehouse or any power cube data source system. Here the packages are located in the public folder as shown in the screenshot:

Once the package is deployed, the default configuration will be applied to the package. Here you can configure the package by using different settings and you need to modify the settings.

One point to remember, to configure a package, you should contain the administrator privilege.

First, you need to package in the public folder -> then click on more buttons -> which come under the action tab as shown below in the following screenshot.

Now click on the button to modify the package configuration -> click on select to analyze. Now it’s time to select the default analysis which is used to define packages -> then the new analysis is generated. Click Ok -> then change the package settings -> then click “Finish”.

Now it’s time to create a package:

Go to the package tab in the public folder -> then create a new package by using IBM Cognos connection.

Select the data source -> you need to use it in the package -> click OK.

Schedule the reports in IBM Cognos:

Here users can also schedule the various reports in IBM Cognos as per the business requirements. Now schedule the report, that allows the user to save the refresh time source-> then you can also define the various scheduling package properties like time zone, start/ end date, and frequency.

To schedule any report -> select the report-> to go to more button as shown in the below screenshot:

You got an option -> then add a new schedule -> now select the new schedule button as shown below:

Here user can select the following methods under the new schedule tab:

1. Frequency

2. Start/end date

3. Priorities

4. Daily frequency set up.

When you define the scheduling property -> you can save it by using the OK button at the bottom tab. Now disable the schedule option -> that will allow users to make any schedule inactive -> but this schedule will be saved on the report.

To edit an existing schedule -> you need to select the report -> to go to more. Here you can also modify an existing schedule time or remove it permanently.

Cognos Framework manager overview:

IBM Cognos framework manager is mainly used to generate a business model of metadata that is derived from one or more data source management. This is a window based tool that is generally used to publish business models to manage the Cognos Business intelligence tool. The Cognos framework consists of packages mainly used for analytical reporting and data analysis purposes.

The fundamental concepts you should follow before you start with Framework manager:

1. Data source which is required to meet Business Intelligence needs.

2. The types of data warehouse systems used.

3. Data refresh in data warehouse management.

4. Business Intelligence reporting – which is available on a daily, weekly, or monthly basis.

Metadata modeling:

A metadata model specifies the collection of various database objects such as tables, columns, and also establishes relationships between the objects. Once you run the report, the metadata published in the business intelligence Cognos portal creates a SQL statement based on the query.

The following diagram explains the framework modeling:

IBM Cognos framework manager user interface:

This framework consists of the following components such as:

1. Project viewer details: This locates on the left side that allows the user to access all the already existing projects in a tree format.

2. Project information: This is available at the center pane used to manage data objects of an existing project. This consists of three tabs such as Explorer, diagram, and dimension view.

3. Properties details: This pane locates at the bottom which is used to set the value for various properties of an object in any project.

4. Tools used: this is located on the right side of the project that provides you the various important useful tools. Here user (you) can perform operations like search, display, or modify already existing objects.

Modelling Relational metadata:

Here once the user imports the metadata, the next step is to validate the object to perform reporting requirements. Users can also select the object that appears in the reporting and testing them. User can create two types of views in the metadata model:

1. Import view

2. Business view

The import view shows whether the metadata is imported from the various data sources. To perform validation of the data you have to perform the following steps:

1. You need to ensure the relationships reflect the reporting requirements.

2. Next step is to optimize and customize the data retrieval from the query subjects.

3. Optimize and customize the data retrieval by business model dimensions. Here you need to store the dimensions in a separate dimensional view.

4. Supporting the multilingual metadata handle.

5. Control how data will be used and those are formatted by verifying the query item properties.

The business view is used to offer the metadata information. With the help of this business view, you can perform operations like calculations, data aggregations, and applying the filters. And also you are able to build the reports easily by using a business view.

Cognos Query studio:

The Query studio is defined as the web based tool for creating the reports and queries in Cognos. This query studio is also used to run simple queries and reports.

1. Viewing the data:

Using the query studio, the user can connect the data source to view the data in a Cognos business tree hierarchy. Here you are able to see query subjects, item details, and query information.

2. Create the BI reports:

Here you can use a query studio to create simple query reports with the help of a data source. You are able to refer to already existing reports to generate a new report.

3. Changing the Existing reports:

You can also change the already existing data reports just by editing the various report layouts such as – Add charts, border styles, titles, and headings.

4. Data customization in reports:

Users can apply different customization techniques in reports, calculations, aggregations, and filters to perform operations like data analysis, drill down, and drill up methods.

Cognos Ad hoc generation:

With the help of ad-hoc reporting, a user can generate data queries and reports to perform analysis. Ad-hoc reporting allows business users to generate simple types of data queries, reports, and dimension tables in DW (data warehouse).

This Query studio in Cognos Business intelligence offers the following features:

1. View the data queries and perform ad hoc data analysis features.

2. Save the reports for any future use.

3. Always helps to work with data in the given report just by applying filters, calculations, and summaries.

4. To create any ad-hoc report you have to follow the navigation; go to query studio -> login to IBM Cognos software-> click on a query on my data as shown in the following screenshot:

Then you have to -> select the report packages. Next time if you want to visit the same page -> you have to see the “selection” under recently used packages -> then click on the package’s name.

In the next screen -> you can add dimension elements, calculations, filters, and prompts.

Here you should insert the objects in order wise. To insert any object in the report -> here you have to use the insert button at the bottom of the query studio screen.

Below is the additional information you can use:

1. Inserting and filtering of the dimension elements.

2. Insertion of filters and prompts.

3. Insert the facts and calculations.

4. Applying the finishing touches.

5. Save, run, share, and collaborate.

At the top toolbar, you can create a new report, save the existing report, paste, cut, insert charts, drill up, and drill down, etc., as shown in the below screenshot.

Cognos Report types:

Here you can make use of different report types in the query studio to meet the business requirements while developing a product. The following are the key report types used in Cognos:

1. List reports: These types of reports are used to define the entire customer base requirements.

2. Cross tab reports: these reports are used to show product quantity sold out and different regions on a different axis.

3. Charts reports: here with the help of this report you can insert charts to show the data graphically. Here you can also combine a chart with a cross tab, or with a list of reports.

Filters calculations and their parameters:

Filters are used to limit the data type that is used in reports. You can also apply one or more filters while creating a Cognos reports and these reports will return the data items that meet the filter requirements or conditions. The following is the navigation to create custom filters in a report:

1. First you should select the column to filter.

2. Then click on the drop-down list -> from the filter button.

3. Now select the create custom filter button.

4. Then you will see the custom conditioning dialog window.

Filters parameters:

1. Condition: to get the condition parameter -> click on the list arrow to see your own choices.

2. Values: to get this parameter -> click on the list arrow to select your choices.

3. Keywords: This parameter allows the user to search for the specific data values available within the list.

4. Values list: with the help of this parameter user can make use of filter values -> then you can choose one or more data values -> then use the arrow buttons -> then click on add multiple values.

Conclusion:

I hope from this cognos tutorial, you may get some idea about how this business intelligence tool can be implemented and its features. This tutorial is best suited for those who are interested to learn data warehouse and visualization methods. The Cognos is emerging as a popular business intelligence tool due to its few major advantages like easy to use, learn, and perform various functionalities. Learning this tutorial will help you to master the few concepts of Cognos and get into a higher position when it comes to the profession.

Related Article:

Cognos Interview Questions