IBM Cognos 10 Report Studio Fundamentals

Your essential training for authoring professional reports that meet business demands
4.1 (32 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.
353 students enrolled
$85
Take This Course
  • Lectures 41
  • Contents Video: 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course Description

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.

What are the requirements?

  • 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.

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Installation, Configuration, and Architecture of Cognos 10 BI
02:03

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

03:29

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

03:16

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

04:04

One-time configuration required before starting the services.

03:57

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

Section 2: Creating Simple and Advanced List Reports
03:21

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

03:31

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.

02:49

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

02:32

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

02:10

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

Section 3: Filters, Prompts, and Calculations
02:47

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.

01:45

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.

02:45

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.

03:40

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.

04:23

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.

Section 4: Creating Simple to Advanced Crosstab Reports
04:23

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

03:50

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.

03:16

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.

03:11

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

04:21

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

Section 5: Using Graphs for Visual Presentation
02:56

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

04:03

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.

04:46

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.

04:04

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

04:31

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

Section 6: Drill Through From a List Report to Another List Report
04:54

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

04:52

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.

04:49

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.

03:36

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.

04:03

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

Section 7: Unleash the Power of Cognos with Macros, HTML items, and JavaScripts
06:24

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.

03:28

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.

02:35

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.

03:51

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.

03:49

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

Section 8: Best Practices and Tricks
04:54

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

04:27

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

03:08

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

01:58

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

02:56

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

03:41

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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Packt Publishing, Tech Knowledge in Motion

Over the past ten years Packt Publishing has developed an extensive catalogue of over 2000 books, e-books and video courses aimed at keeping IT professionals ahead of the technology curve. From new takes on established technologies through to the latest guides on emerging platforms, topics and trends – Packt's focus has always been on giving our customers the working knowledge they need to get the job done. Our Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.

Ready to start learning?
Take This Course