IBM Cognos 10 Report Studio Fundamentals [Video]

IBM Cognos 10 Report Studio Fundamentals [Video]

Starting
Abhishek Sanghani

$25.50
RRP $84.99
$12.99 p/month

Want this title & more? Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.
+ Collection
Free Sample

Video Details

ISBN 139781849689281
Course Length2 hours 50 mins

About This Video

  • Understand the fundamentals and architecture of Cognos 10 Report Studio to become proficient with the tool
  • Move on from simple to advanced techniques by watching purely example -driven videos that peek into the best practices used in the industry
  • Overcome tool-based limitations by achieving speedy and effortless report development
  • Rewind, replay, and practice the techniques yourself using our downloadable examples
  • Suitable for most versions of Report Studio (v8.2, v8.4 and v10.x)

Who This Video Is For

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.

Table of Contents

Installation, Configuration, and Architecture of Cognos 10 BI
Downloading Cognos Installer
Installing Cognos 10 BI Developer Edition
Components and Architecture of Cognos 10 BI
Cognos Configuration and Starting Services
Connection Portal
Creating Simple and Advanced List Reports
Creating a Simple List Report
Adding Data Formatting, Grouping, and Sorting Features
Applying Simple to Advanced Conditional Styles
Adding Page Breaks by Creating Sections
Examining Query Subjects and the Generated SQL
Filters, Prompts, and Calculations
Adding Custom Calculations to a List
Filtering Data Using Detailed Filters
Parameterizing the Filter and Adding Prompts
Adding Query-driven Value Prompts
Changing the Prompt's Display Value in the Prompt Page
Creating Simple to Advanced Crosstab Reports
Using Crosstab Reports to Show Orders against Cities and Products
Adding Crosstab Totals (Summary), Zero Suppression, and Date Range Prompts
Adding Additional Levels and Measures by Nesting Rows or Columns
Discontinuous Crosstab
Overriding Cell Contents
Using Graphs for Visual Presentation
Creating a Simple Chart Showing Sales over Countries and Product Lines
Projecting Multiple Measures on Charts and Other Refinements
Nesting Items in a Chart, Filtering, and Some More Properties
Chart inside a list & Master-Detailed Relationship
Enable Chart Properties and Create a 3D Bubble Chart
Drill Through From a List Report to Another List Report
Creating a Drill-through from a List Report to Another
Passing Multiple Parameters in Drill-through: From a Chart to a List
Enabling Drill Up and Drill Down in Dimensional Models
Drill Through to Itself to Mimic Exporting to Excel or PDF
Conditional Drill-through Definitions
Unleash the Power of Cognos with Macros, HTML items, and JavaScripts
Dynamically Changing Report Columns Using Macro Functions
Creating an E-mail Link Using an HTML Item
Linking to Google Maps Using the HYPERLINK Object
Using JavaScript to Manipulate a Value Prompt
Using JavaScript to Show or Hide Prompt Controls
Best Practices and Tricks
Reusing Objects and Reducing Maintenance
Creating Report Templates
Horizontal Pagination and PDF Page Sizing
Displaying a NO DATA message
Adding Code Comments into Reports
Copying Reports and Version Controlling

What You Will 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

In Detail

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.

Authors

Screenshots

Table of Contents

Installation, Configuration, and Architecture of Cognos 10 BI
Downloading Cognos Installer
Installing Cognos 10 BI Developer Edition
Components and Architecture of Cognos 10 BI
Cognos Configuration and Starting Services
Connection Portal
Creating Simple and Advanced List Reports
Creating a Simple List Report
Adding Data Formatting, Grouping, and Sorting Features
Applying Simple to Advanced Conditional Styles
Adding Page Breaks by Creating Sections
Examining Query Subjects and the Generated SQL
Filters, Prompts, and Calculations
Adding Custom Calculations to a List
Filtering Data Using Detailed Filters
Parameterizing the Filter and Adding Prompts
Adding Query-driven Value Prompts
Changing the Prompt's Display Value in the Prompt Page
Creating Simple to Advanced Crosstab Reports
Using Crosstab Reports to Show Orders against Cities and Products
Adding Crosstab Totals (Summary), Zero Suppression, and Date Range Prompts
Adding Additional Levels and Measures by Nesting Rows or Columns
Discontinuous Crosstab
Overriding Cell Contents
Using Graphs for Visual Presentation
Creating a Simple Chart Showing Sales over Countries and Product Lines
Projecting Multiple Measures on Charts and Other Refinements
Nesting Items in a Chart, Filtering, and Some More Properties
Chart inside a list & Master-Detailed Relationship
Enable Chart Properties and Create a 3D Bubble Chart
Drill Through From a List Report to Another List Report
Creating a Drill-through from a List Report to Another
Passing Multiple Parameters in Drill-through: From a Chart to a List
Enabling Drill Up and Drill Down in Dimensional Models
Drill Through to Itself to Mimic Exporting to Excel or PDF
Conditional Drill-through Definitions
Unleash the Power of Cognos with Macros, HTML items, and JavaScripts
Dynamically Changing Report Columns Using Macro Functions
Creating an E-mail Link Using an HTML Item
Linking to Google Maps Using the HYPERLINK Object
Using JavaScript to Manipulate a Value Prompt
Using JavaScript to Show or Hide Prompt Controls
Best Practices and Tricks
Reusing Objects and Reducing Maintenance
Creating Report Templates
Horizontal Pagination and PDF Page Sizing
Displaying a NO DATA message
Adding Code Comments into Reports
Copying Reports and Version Controlling

Video Details

ISBN 139781849689281
Course Length2 hours 50 mins
Read More