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 ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
