Book Image

IBM Cognos 10 Report Studio Fundamentals [Video]

By : Abhishek Sanghani
Book Image

IBM Cognos 10 Report Studio Fundamentals [Video]

By: Abhishek Sanghani

Overview of this book

<p>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 &amp; JavaScript and Macros.</p> <p>"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.<br /><br />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.<br /><br />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.<br /><br />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.</p> <h1>Style and Approach</h1> <p>Packt video courses are designed to cover the breadth of the topic in short, hands-on, task-based videos. Each course is divided into short manageable sections, so you can watch the whole thing or jump to the bit you need. The focus is on practical instructions and screencasts showing you how to get the job done.</p> <p>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.</p>
Table of Contents (8 chapters)
Chapter 6
Drill Through From a List Report to Another List Report
Content Locked
Section 3
Enabling Drill Up and Drill Down in Dimensional Models
Normal 0 false false false EN-IN X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm; mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-fareast-language:EN-US;} 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. - Create a crosstab report against a Dimensionally Modeled Relational (DMR) package - Drag the required dimensions and measures - Enable the native drill-up and drill-down features