Filip Draskovic - IBM Cognos 10 Report Studio Practical Examples

Practical Examples

Filip Draskovic
Roger Johnson

IBM Press
Pearson plc
Upper Saddle River, NJ Boston Indianapolis San Francisco
New York Toronto Montreal London Munich Paris Madrid
Cape Town Sydney Tokyo Singapore Mexico City

The authors and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein.

Copyright 2012 by International Business Machines Corporation. All rights reserved.

Note to U.S. Government Users: Documentation related to restricted right. Use, duplication, or disclosure is subject to restrictions set forth in GSA ADP Schedule Contract with IBM Corporation.

IBM Press Program Managers: Steven M. Stansel, Ellice Uffer
Cover design: IBM Corporation

Associate Publisher: Dave Dusthimer
Marketing Manager: Stephane Nakib
Executive Editor: Mary Beth Ray
Publicist: Andrea Bledsoe
Senior Development Editor: Christopher Cleveland
Managing Editor: Kristy Hart
Designer: Alan Clements
Technical Editors: Sue Mitchell, Ronald Olenic
Senior Project Editor: Lori Lyons
Copy Editor: Cheri Clark
Indexer: Brad Herriman
Compositor: Nonie Ratcliff
Proofreader: Water Crest Publishing
Manufacturing Buyer: Dan Uhrig

Published by Pearson plc
Publishing as IBM Press

IBM Press offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include electronic versions and/or custom covers and content particular to your business, training goals, marketing focus, and branding interests. For more information, please contact

U.S. Corporate and Government Sales
1-800-382-3419

For sales outside the U. S., please contact

International Sales

The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: IBM, the IBM Press logo, Cognos, and SPSS. Other company, product, or service names may be trademarks or service marks of others.

Library of Congress Cataloging-in-Publication Data
Johnson, Roger.
IBM Cognos 10 Report Studio : practical examples / Roger Johnson, Filip Draskovic.
p. cm.
ISBN 978-0-13-265675-7 (pbk.)
1. Business intelligenceComputer programs. 2. Business report writingComputer programs.
3. Database managementComputer programs. 4. IBM software. I. Draskovic, Filip. II. Title.
HD38.7.J63 2012
651.7'4028553dc23
2011032352

All rights reserved. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permissions, write to:

Pearson Education, Inc
Rights and Contracts Department
501 Boylston Street, Suite 900
Boston, MA 02116
Fax (617) 671 3447

Text printed in the United States on recycled paper at R.R. Donnelley in Crawfordsville, Indiana.
First printing October 2011

ISBN-13: 978-0-13-265675-7
ISBN-10: 0-13-265675-2

Id like to thank my wife, Danijela, for encouragement and support throughout the writing of this book and for letting me check one item off my bucket list. I also would like to thank my son Luka and daughter Mia for showing me what really is important in life and my parents for showing me that hard work and perseverance do pay off.

Filip Draskovic

Id like to thank my wife, Pearl, and daughters, Sylvie and Sapphire, for allowing me to make the work/life balance lean too heavily in one direction. The love you give means so much to me. I also want to thank my parents, Bill and Pat, for all of their love and support over the years.

Roger Johnson

First, we would like to acknowledge all the Cognoids out there who have encouraged us to think beyond the course material and to look deeper into the functions of IBM Cognos Business Intelligence.

We would like to thank the crew at IBM Press for the opportunity to share this book with you. Our technical reviewers, Ronald Olenic and Sue Mitchell, provided some wonderful insights and even taught us a few more things that found their way into this book. Thanks go to Chris Cleveland for his help in bringing the best possible product to our readers.

Thank you to our Executive Editor, Mary Beth Ray, for allowing us the opportunity to create this book on a flexible schedule.

Being a part of a great team like the IBM North American Education Services Team, we would like to thank all of our peers on the team who shared tips with fellow educators and asked for new ways to answer student reporting questions.

We would also like to thank Jesus Salcedo for his assistance in reviewing the statistical analysis example. His understanding of statistics, matched with his passion, is an inspiration to us nonstatisticians.

Roger would like to thank Nathan Nyvall as the manager who interviewed him five years ago for the education specialist position and started him down the path of business analytics education. It has led to a continued effort toward world domination.

Also, he would like to thank Filip for teaming together on our international efforts in this book. I think we did a pretty good job.

Filip would like to thank Roger for talking him into doing this book and teaching him patience.

Filip Draskovic has spent his professional career, which covers the past 11 years, living and breathing IBM Cognos. For the first 8 years of his career, he had been an IBM Cognos consultant and developed his skills applying IBM Cognos Business Intelligence and Planning solutions in multiple industries. Wanting to do something different, he spent the next 3 years as a Cognos trainer teaching public and private IBM Cognos courses in IBMs offices around North America. Following his desire to constantly gain new experiences and knowledge, he is currently filling the role of an IBM Cognos client technical professional. You can find him today in Torontos financial district. At home, with his wife, he is enjoying raising their son and daughter.

Roger Johnson is a learning consultant on IBM Cognos technologies delivering a wide variety of courses focusing on the needs of his learners. His education experience has been honed over years of work in training software professionals, college students, and many types of technology users. After he started his career as a computer programmer, a co-worker said, Hey, you do community theater productions. You would make a good trainer. With those words, his career took a different direction. Over the next 20 years, he never moved too far from either technology or education. As a learner, he has masters degrees in Systems Management and Education. Currently, he is researching the end-user adoption of technology as his doctoral dissertation at Capella University. He calls Orlando home, but is regularly seen around North America delivering any number of IBM Cognos courses. When he is home, he enjoys the time he gets to spend with family, and his dogs keep him busy jogging around the lake.

When I was eight, I had a friend who could build absolutely anything out of those little bright-colored, plastic interlocking blocks. Spaceship with wings, solar-powered treehouse, prehistoric monster; you name it, he could build it. He had one giant pillowcase full of the blocks, and a stack of instructions by his bedside. I remember him looking at the step-by-step guides, picking and choosing among the patterns, and then combining them to provide me with the monster truck equipped with water skis that I had requested.