Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying IBM Cognos 10 Report Studio Cookbook, Second Edition
  • Table Of Contents Toc
IBM Cognos 10 Report Studio Cookbook, Second Edition

IBM Cognos 10 Report Studio Cookbook, Second Edition - Second Edition

3.6 (9)
close
close
IBM Cognos 10 Report Studio Cookbook, Second Edition

IBM Cognos 10 Report Studio Cookbook, Second Edition

3.6 (9)

Overview of this book

IBM Cognos Report Studio is widely used for creating and managing business reports in medium to large companies. It is simple enough for any business analyst, power user, or developer to pick up and start developing basic reports. However, this book is designed to take the reader beyond the basics and into the world of creating more sophisticated, functional business reports.IBM Cognos 10 Report Studio Cookbook, Second Edition helps you understand and use all the features provided by Report Studio to generate impressive deliverables. It will take you from being a beginner to a professional report author. It bridges the gap between basic training provided by manuals or trainers and the practical techniques learned over years of practice.Written in a recipe style, this book offers step-by-step instructions for IBM Cognos Report Studio users to author reports effectively, allowing a reader to dip in and out of the chapters as they desire. You will see a new fictional business case in each recipe that will relate to a real-life problem and then you will learn how to crack it in Report Studio. This book covers all the basic and advanced features of Report Authoring. It introduces the fundamental features useful across any level of reporting. Then it ascends to advanced techniques and tricks to overcome Studio limitations. Develop excellent reports using dimensional data sources by following best practices that development work requires in Report Studio. You will also learn about editing the report outside the Studio by directly editing the XML specifications. You will discover how to build and use Cognos Active Reports, a new addition in IBM Cognos 10. Provide richness to the user interface by adding JavaScript and HTML tags and using the different chart types introduced in IBM Cognos 10. The main focus is on the practical use of various powerful features that Report Studio has to offer to suit your business requirements. Learn numerous techniques and hacks that will allow you to make the best out of your IBM Cognos 10 Report Studio.
Table of Contents (21 chapters)
close
close
IBM Cognos 10 Report Studio Cookbook Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
2
Index

Missing values versus zero values


Missing values in the data source can mean two things in real business: either the data is zero or it is missing. For example, in the case of a sales transaction-based system, if there is no data for a product for a certain month, it means there was no sale of that product in that month. However, in some other systems, for example, yearly returns of different stocks missing data might just mean that data is not available for a certain reason. However, it certainly doesn't mean the return was zero.

Hence, it is important to clearly highlight the missing value as zero or missing in the report.

Getting ready

Create a simple crosstab report with all Product line on rows and Month key on columns from GO Data Warehouse (Query)/Sales. Choose Quantity and Unit cost as sales measures.

How to do it...

In this recipe we will see how to avoid missing values in the report by replacing them with more meaningful values like zero or N/A.

  1. Firstly, we will run the report to see...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
IBM Cognos 10 Report Studio Cookbook, Second Edition
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon