Cognos Event Studio is a Web-based tool that allows you to create and manage agents to monitor data and perform tasks when the data meets predefined thresholds.

Events

You can specify an event condition to perform a task. An event is defined as query expression in a data package.
When a record matches the event condition, it causes an agent to perform tasks. When an agent runs, it checks the data for any event instances.

Event Instance

An agent monitors data, each event instance is detected. Task execution rules are followed to determine if an agent will perform the task. Task frequency defines that a task should be performed once or repeated for each event instance.

Event List

You can categorize the event as per the task performed. The event list shows all the events that are executed by an agent. Different event categorization includes −

• New
• Ongoing and Changed
• Ongoing and Unchanged
• Ceased

An event key is used to determine whether an event is new, ongoing but changed, ongoing and unchanged, or ceased. Event Studio compares the event instances detected in each agent run with those detected in the previous run. To ensure it correctly matches the event instances for comparison, you must define an event key. The event key is the combination of data items that uniquely defines an event instance.

Agent

An agent runs to check occurrences of the event. An agent performs a task for events that meet the execution rules.

Tasks

A task can be used to notify users about a change in business event. Users can take appropriate actions as per the event.
You can create a task for the following functions −

• Add an Item
• Send an Email
• Publish a new item
• Run a Job
• Run an import
• Run an Export and many more.

Cognos – Query Studio

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.

Cognos – Ad-hoc Reports

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.

Cognos – Report Types

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.

Cognos – Notification Methods

An agent can use different notification methods to notify business users. An agent can notify business users by −

• An email to business users.
• Publishing a news item to a folder frequently used by users.

Email to Business Users

You can notify people by email using either a report task or an email task. To help you decide which method to use, you should understand how they differ.
You can use either a report task or an email task −

• To send a single email text message.
• To attach a single report in the specified output formats.
• If you attach only one HTML report and leave the body field empty, the report appears in the message body.
• To add links to a single report for the specified output formats.

News Item Published

In this, you can publish a news item/headline to a folder whose content can be viewed in a Cognos Navigator portlet and in any folder view. When a Business user clicks on the headline, it can open the content or view it as a web page.

So, this brings us to the end of blog. This Tecklearn ‘Cognos Studios and other capabilities’ blog helps you with commonly asked questions if you are looking out for a job in Cognos BI. If you wish to learn Cognos Analytics and build a career in Business Intelligence domain, then check out our interactive, IBM Cognos Analytics Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

IBM Cognos Analytics 11 Training

IBM Cognos Analytics 11 Training

About the Course

IBM Cognos 11 training provides in-detailed knowledge on how to build complex and advanced reports and dashboards using IBM Cognos reporting tool, and this will enable you to become a Cognos developer. Major topics of this Cognos reports and dashboard training include Cognos architecture, the components of Cognos, Analysis Studio, OLTP system, Query Studio, advanced report designing, Cognos Framework Manager and Cognos Administration. By the end of this training, you will get an insight into working with IBM Cognos reporting tool by implementing real-time Cognos projects, and you will be able to use this knowledge in real-time environments.

Why Should you take IBM Cognos Analytics 11 Training?

• The average Cognos developer salary is $78417 or an equivalent hourly rate of $38-Erieri.com.
• Cognos has a market share of around 9% globally.
• Cognos Analytics V11 enhances the efficiency and capabilities of business users, report authors, and administrators alike through a simplification of and the graduated nature of its user experience.

What you will Learn in this Course?

Overview of IBM Cognos BI and Cognos BI Architecture

• Overview of IBM Cognos Analytics 11
• IBM Cognos Framework Manager Modelling
• New UI features of Cognos Analytics 11

Cognos Analytics 11: Data Modules

• Overview of Cognos Analytics 11 Data Modules
• Creation of Data Server Connection
• Using Data Modules to modulate data without using the Framework Manager
• Data Discovery through intent-based modelling
• Creating Data modules with inputs from various sources

Working with Dashboards

• Process of Dashboarding in IBM Cognos
• Creating a Dashboard
• Filter Data in Dashboard
• Widget-to-Widget Communication
• Sorting, Grouping and Calculating Data
• Storytelling

Cognos Environment

• Active Report
• New Visualization Types
• Sharing and Embedding Contents

Cognos Reports

• Cognos Report Studio
• Reporting using Filters, Formatting, Charts
• Advance Report Building Techniques
• Cognos Active Reports
• Geo Spatial Analytics

Cognos Administration

• Deep Dive into Cognos Administration
• Analysing and Administering Queries

Dimension Modelling

• New Features in Smart Modelling
• Transformer Cube and Drill through
• Dynamic Cube and Drill Though

569