IBM Cognos 10 Report Studio Fundamentals
4.1 (126 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
804 students enrolled
Wishlisted Wishlist

Please confirm that you want to add IBM Cognos 10 Report Studio Fundamentals to your Wishlist.

Add to Wishlist

IBM Cognos 10 Report Studio Fundamentals

Your essential training for authoring professional reports that meet business demands
4.1 (126 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
804 students enrolled
Created by Packt Publishing
Last updated 10/2015
Price: $85
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Install Cognos 10 Report Studio and understand its architecture
  • Create List Reports and perform data formatting, grouping, and sorting
  • Explore the powerful features of Report Studio— conditional styles, data filters, page breaks, prompts & calculations
  • Examine underlying SQL queries which are fired on the database
  • Achieve dynamically changing columns using macros
  • Use HTML items effectively to create email links and Google Map links
  • Manipulate prompts using JavaScript
  • Create crosstab reports, nesting reports , master-detail reports, and zero suppression reports
  • Add different types of charts to reports
  • Set up Drill Through and Drill Down links
  • Use Report Templates, Copy-Paste & Adding Code Comments effectively
  • Save time on maintenance by using Layout Component Reference
View Curriculum
  • A self paced, example-driven, clear and concise online video course with code samples to equip you with the skills required to build powerful reports using Cognos Report Studio in a short time. Each task is a carefully organized sequence of instructions to complete the task as efficiently as possible.

IBM Cognos Report Studio is a powerful web-based business report writing tool. It gives you a simple drag-n-drop interface to quickly create data-based reports without worrying about how it connects to the database and pulls data. This course exposes you to the unlimited possibilities of extending your simple business reports to advanced levels using HTML & JavaScript and Macros.

IBM Cognos 10 Report Studio Fundamentals covers the basic and advanced features of report authoring. It helps you understand and use all the features provided by Report Studio to generate impressive deliverables to take you from being a beginner to a professional report author. Develop excellent reports using dimensional data sources by following best practices in this course.

Starting with an overview of high-level architecture and installation of Cognos 10 Report Studio , you will progress from building simple to advanced List and Crosstab reports and much more. Each topic is shown with working examples, in a clear and concise way to enable you to quickly grasp and practice these.
You will see how to add data formatting, conditional layouts, and filters to your reports to use them effectively. You define how to format numbers, present data into charts or matrix, and link the reports together. You will learn how to stay in control by examining underlying queries and pick up best practices like using layout component references, templates and code comments.
In short, Cognos 10 Report Studio Fundamentals will help you get the best out of Cognos 10 Report Studio. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements and enable you to start building professional reports on your own.

Who is the target audience?
  • Whether you are an Analyst, Business User, Project Manager or a Techie who is new to Cognos Report Studio, you will gain understanding of how things work and put them to action.
  • You could also be an End user or a Project Manager who authors his own reports and wants to look beyond the conventional features of Cognos 10 Report Studio.
Compare to Other Cognos Courses
Curriculum For This Course
41 Lectures
Installation, Configuration, and Architecture of Cognos 10 BI
5 Lectures 16:49

IBM now provides a free 30-day trial version of Cognos BI. Get ready, get going!

Downloading Cognos Installer

These are the essential settings for your laptop/desktop before performing the installation. Saves a lot of hassle!

Installing Cognos 10 BI Developer Edition

New to Cognos BI? Understand the high-level architecture here.

Components and Architecture of Cognos 10 BI

One-time configuration required before starting the services.

Cognos Configuration and Starting Services

Welcome to Cognos Connection Portal, your entry point to Business Intelligence.

Connection Portal
Creating Simple and Advanced List Reports
5 Lectures 14:23

By doing a quick drag-n-drop operation, you can create a list report in minutes to display required data from the database.

Creating a Simple List Report

Appropriate formatting, grouping, and sorting are essential to present the data nicely in reports. Add data formatting like decimal points and the currency symbol. Also define grouping, sorting, and group span.

Adding Data Formatting, Grouping, and Sorting Features

Use the powerful feature of conditional styling to highlight records that meet certain criteria. For example, show traffic.

Applying Simple to Advanced Conditional Styles

Adding a page break is essential in certain cases; especially when the report is meant for printing and distribution.

Adding Page Breaks by Creating Sections

See how Cognos pulls data from the database and how to rename query subjects according to best practices.

Examining Query Subjects and the Generated SQL
Filters, Prompts, and Calculations
5 Lectures 15:20

We are not limited to only pulling data items from the model. We can also create our own calculation to add logic and value to those data items. As an example, we will compute the order value by multiplying price with quantity.

Adding Custom Calculations to a List

There usually are thousands or millions of records in a database. You might not want to show all of them; actually, you need to concentrate only on the significant ones. We will see how to achieve that using a filter on the order value.

Filtering Data Using Detailed Filters

Instead of hardcoding the order value threshold to 2000 USD, we will now introduce a parameter and create a prompt page where users can type in the threshold value when running reports. This gives control back into the users' hands to decide the details they would like to see.

Parameterizing the Filter and Adding Prompts

The user need not always type in the values for prompts. Instead, we can show advanced controls like checkboxes / listboxes / radio buttons and drive the options using another query. In this example, we will populate customer numbers in a listbox for user selection.

Adding Query-driven Value Prompts

We will now show the customer names with their corresponding numbers in brackets to make it more user friendly. We also tidy up the prompt page to make it look neater.

Changing the Prompt's Display Value in the Prompt Page
Creating Simple to Advanced Crosstab Reports
5 Lectures 19:01

We start with your first crosstab or matrix report to show order quantities over cities and products.

Using Crosstab Reports to Show Orders against Cities and Products

See how to add quantity totals in the row and column summaries and filter data using the date range. Also define suppression to hide zero rows and columns.

Adding Crosstab Totals (Summary), Zero Suppression, and Date Range Prompts

Nesting allows us to split the rows and columns into more categories. We will use it to display additional measures and further split up data.

Adding Additional Levels and Measures by Nesting Rows or Columns

By extending the crosstab to display an additional dimension next to existing rows, we will create a discontinuous or disjointed crosstab.

Discontinuous Crosstab

See how to override certain cell contents to display text, images, or other objects in the crosstab.

Overriding Cell Contents
Using Graphs for Visual Presentation
5 Lectures 20:20

Shows how to create a color-coded or stacked bar chart showing sales over different countries in various product lines.

Creating a Simple Chart Showing Sales over Countries and Product Lines

After creating a simple chart in three minutes, we now move on to adding more measures/data and make other changes to the chart properties.

Projecting Multiple Measures on Charts and Other Refinements

This video shows how to add an extra level to the categories to achieve a more granular chart for cities, grouped by countries. We also add a data filter and touch upon more chart properties such as axis titles and the legend.

Nesting Items in a Chart, Filtering, and Some More Properties

Project sales trend using micro-charts inside a list report showing product information.

Chart inside a list & Master-Detailed Relationship

This video shows how to enable advanced chart features of Cognos 10 and display colored regions in a chart.

Enable Chart Properties and Create a 3D Bubble Chart
Drill Through From a List Report to Another List Report
5 Lectures 22:14

For a report that shows orders' data, we would like to provide a hyperlink for the product codes.

Creating a Drill-through from a List Report to Another

When we call another report using drill-through, we can pass more than one data item or prompt value to work as context in the target report. Let's see how to pass multiple values from a chart report to a list report.

Passing Multiple Parameters in Drill-through: From a Chart to a List

Cognos has an in-built functionality to drill down and up over the levels if the source report is the dimension. Let us see how to enable and use it.

Enabling Drill Up and Drill Down in Dimensional Models

We will learn how drilling through links from a report to itself can be useful to mimic exporting to PDF or to mimic Excel behavior.

Drill Through to Itself to Mimic Exporting to Excel or PDF

Let's learn how to switch the drill targets using conditional rendering.

Conditional Drill-through Definitions
Unleash the Power of Cognos with Macros, HTML items, and JavaScripts
5 Lectures 20:07

This video shows you how to enable users to select the columns they would like to see on the report. We will use the PROMPT macro function to achieve this.

Preview 06:24

We create an e-mail link using HTML items on the report, which enables users to click on any e-mail ID and initiate a new e-mail.

Preview 03:28

Let's see how we can use the HYPERLINK object to create a dynamic link to Google Maps and show the location of a customer, using their post code and country name.

Preview 02:35

This video shows you how we can use JavaScript to make a default selection for the LISTBOX prompt when the page loads. As the listbox values are already sorted in the descending order, we choose the first value to default the report to the latest order date.

Preview 03:51

In this video, we see how JavaScript can be used on the prompt page to show or hide certain prompts.

Preview 03:49
Best Practices and Tricks
6 Lectures 21:04

This video shows how Layout Component References can be used to re-use objects and save on maintenance.

Reusing Objects and Reducing Maintenance

See how to create report templates to save time and maintain consistency.

Creating Report Templates

Stop reports from showing columns over multiple pages and change the PDF page properties to fit all contents.

Horizontal Pagination and PDF Page Sizing

We see how to display a message when a list report has no data to show.

Displaying a NO DATA message

As a best practice, we should put comments in complex calculations, filters, and pages. This video shows how to do that.

Adding Code Comments into Reports

A very basic but must-know process is how to copy parts of reports and entire reports from one Report Studio to another.

Copying Reports and Version Controlling
About the Instructor
Packt Publishing
3.9 Average rating
8,249 Reviews
59,064 Students
687 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.