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.
IBM now provides a free 30-day trial version of Cognos BI. Get ready, get going!
These are the essential settings for your laptop/desktop before performing the installation. Saves a lot of hassle!
New to Cognos BI? Understand the high-level architecture here.
One-time configuration required before starting the services.
Welcome to Cognos Connection Portal, your entry point to Business Intelligence.
By doing a quick drag-n-drop operation, you can create a list report in minutes to display required data from the database.
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.
Use the powerful feature of conditional styling to highlight records that meet certain criteria. For example, show traffic.
Adding a page break is essential in certain cases; especially when the report is meant for printing and distribution.
See how Cognos pulls data from the database and how to rename query subjects according to best practices.
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.
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.
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.
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.
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.
We start with your first crosstab or matrix report to show order quantities over 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.
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.
By extending the crosstab to display an additional dimension next to existing rows, we will create a discontinuous or disjointed crosstab.
See how to override certain cell contents to display text, images, or other objects in the crosstab.
Shows how to create a color-coded or stacked bar chart showing sales over different countries in various 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.
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.
Project sales trend using micro-charts inside a list report showing product information.
This video shows how to enable advanced chart features of Cognos 10 and display colored regions in a chart.
For a report that shows orders' data, we would like to provide a hyperlink for the product codes.
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.
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.
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.
Let's learn how to switch the drill targets using conditional rendering.
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.
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.
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.
This video shows how Layout Component References can be used to re-use objects and save on maintenance.
See how to create report templates to save time and maintain consistency.
Stop reports from showing columns over multiple pages and change the PDF page properties to fit all contents.
We see how to display a message when a list report has no data to show.
As a best practice, we should put comments in complex calculations, filters, and pages. This video shows how to do that.
A very basic but must-know process is how to copy parts of reports and entire reports from one Report Studio to another.
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.