IBM Cognos 10 Report Studio Fundamentals – Packt Publishing

Salepage link: At HERE. Archive: http://archive.is/wip/AoeR1

IBM Cognos 10 Report Studio Fundamentals

Your essential training for authoring professional reports that meet business demands

Your essential training for authoring professional reports that meet business demands

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)

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.

Course Curriculum

Installation, Configuration, and Architecture of Cognos 10 BI

• Downloading Cognos Installer (2:03)
• Installing Cognos 10 BI Developer Edition (3:29)
• Components and Architecture of Cognos 10 BI (3:16)
• Cognos Configuration and Starting Services (4:04)
• Connection Portal (3:58)

Creating Simple and Advanced List Reports

• Creating a Simple List Report (3:21)
• Adding Data Formatting, Grouping, and Sorting Features (3:32)
• Applying Simple to Advanced Conditional Styles (2:49)
• Adding Page Breaks by Creating Sections (2:32)
• Examining Query Subjects and the Generated SQL (2:10)

Filters, Prompts, and Calculations

• Adding Custom Calculations to a List (2:47)
• Filtering Data Using Detailed Filters (1:45)
• Parameterizing the Filter and Adding Prompts (2:45)
• Adding Query-driven Value Prompts (3:40)
• Changing the Prompt’s Display Value in the Prompt Page (4:23)

Creating Simple to Advanced Crosstab Reports

• Using Crosstab Reports to Show Orders against Cities and Products (4:23)
• Adding Crosstab Totals (Summary), Zero Suppression, and Date Range Prompts (3:50)
• Adding Additional Levels and Measures by Nesting Rows or Columns (3:17)
• Discontinuous Crosstab (3:11)
• Overriding Cell Contents (4:21)

Using Graphs for Visual Presentation

• Creating a Simple Chart Showing Sales over Countries and Product Lines (2:57)
• Projecting Multiple Measures on Charts and Other Refinements (4:03)
• Nesting Items in a Chart, Filtering, and Some More Properties (4:46)
• Chart inside a list & Master-Detailed Relationship (4:04)
• Enable Chart Properties and Create a 3D Bubble Chart (4:31)

Drill Through From a List Report to Another List Report

• Creating a Drill-through from a List Report to Another (4:54)
• Passing Multiple Parameters in Drill-through: From a Chart to a List (4:52)
• Enabling Drill Up and Drill Down in Dimensional Models (4:49)
• Drill Through to Itself to Mimic Exporting to Excel or PDF (3:36)
• Conditional Drill-through Definitions (4:04)

Unleash the Power of Cognos with Macros, HTML items, and JavaScripts

• Dynamically Changing Report Columns Using Macro Functions (6:24)
• Creating an E-mail Link Using an HTML Item (3:28)
• Linking to Google Maps Using the HYPERLINK Object (2:36)
• Using JavaScript to Manipulate a Value Prompt (3:51)
• Using JavaScript to Show or Hide Prompt Controls (3:49)

Best Practices and Tricks

• Reusing Objects and Reducing Maintenance (4:54)
• Creating Report Templates (4:27)
• Horizontal Pagination and PDF Page Sizing (3:08)
• Displaying a NO DATA message (1:58)
• Adding Code Comments into Reports (2:56)
• Copying Reports and Version Controlling (3:41)