Book Image

IBM Cognos 10 Framework Manager

By : Terence Phillip Curran
Book Image

IBM Cognos 10 Framework Manager

By: Terence Phillip Curran

Overview of this book

"IBM Cognos 10 Framework Manager" is a complete practical guide to using and getting the best out of this essential tool for modeling your data for use with IBM Cognos Business Intelligence Reporting. With its step-by-step approach, this book is suitable for anyone from a beginner to an expert, complete with tips and tricks for better data modeling."IBM Cognos 10 Framework Manager" is a step by step tutorial-based guide; from importing your data to designing and improving your model, and creating your packages while working with other modelers, every step is presented in a logical process.Learn how to use the best design strategy to design your model, create an import layer, a modeling layer, and a presentation layer to make your model easy to maintain. Do you need to design a DMR model? No problem, this book shows you every step. This book can even make working with other users easier - we will show you the methods and techniques for allowing others to work on the same model at the same time. Need to create dynamic data structures to change the way the data is presented to your users so your French users can see the data in French, your German users in German, and your English users in English? You can do all this with parameter maps."IBM Cognos 10 Framework Manager" continues where the product manuals end, showing you how to build and refine your project through practical, step by step instructions.
Table of Contents (19 chapters)
IBM Cognos 10 Framework Manager
About the Author
About the Reviewer


IBM Cognos Framework Manager is a modeling tool for creating and managing business related metadata available in all Cognos Business Intelligence applications. It allows modelers to model relational data dimensionally, apply hierarchies to allow drill behaviors, apply member functions, and query any of the supported data sources (relational database with SQL or OLAP with MDX).

The main users of Framework Manager are data warehouse developers and data modelers. Report authors use the metadata information, which is set up using Framework Manager when creating new reports.

It is not a standalone product, but a core backend tool used to build a foundation for Query Studio, Report Studio, and Analysis Studio.

What this book covers

Chapter 1, Getting Started, provides an overview of the configuration of Framework Manager, including details of how to run Framework Manager, and the main features of the user interface.

Chapter 2, Proven Practice, covers the proven practices to use when you are designing a new data model in Framework Manager.

Chapter 3, Importing Data Sources, covers the details of the different types of data sources that Framework Manager can import, and how to import your data sources.

Chapter 4, Modeling Relational Data, covers the modeling of the relationships between the data tables. After importing your metadata you must ensure it meets your users' reporting requirements.

Chapter 5, Modeling Dimensional Data, covers the use of Dimensional Modeling – more correctly Dimensionally Modeled Relational data (DMR).

Chapter 6, Creating the Business and Presentation Layers, covers the creation of the Business and Presentation layers. The Business layers are layers where we add business rules to our model to make it more user friendly. The Presentation layer is what your report authors will see in Report Studio, Query Studio, and Analysis Studio.

Chapter 7, Creating and Publishing Packages, covers the creation and publishing of your packages. Once all the layers of the model have been created we have to present the model to your report authors for them to use.

Chapter 8, Maintaining Projects, covers the techniques for ensuring that changes to the data sources are reflected in your model. This chapter also covers the techniques to allow multi-user modeling.

Chapter 9, Model Design Accelerator, covers Model Design Accelerator, which simplifies the creation of relational star schema models. It will assist both novice and expert modelers to build Framework Manger models without needing extensive experience and training.

Chapter 10, Parameter Maps, covers Parameter Maps, which can be used to create conditional query subjects that allow for substitutions when a report is run.

Appendix, Data Warehouse Schema Map, shows details of the Schema Map for the Data Warehouse used in Chapter 9, Model Design Accelerator.

What you need for this book

To use the examples in this book you will need a copy of IBM Cognos Framework Manager, and this software is only available as a Microsoft Windows program.

All examples have been developed using IBM Cognos Framework Manager 10.1.1.

The examples in Chapter 9, Model Design Accelerator, will only work with IBM Cognos Framework Manager 10, since this was a new feature in IBM Cognos 10.

All other examples should work with any version of IBM Cognos Framework Manager.

To function correctly, Framework Manager requires a suitably configured IBM Cognos Business Intelligence Server. Many of the examples make use of the IBM Cognos Business Intelligence Samples, so the following software is also required:

  • IBM Cognos Business Intelligence Server – this needs to be the same version as Framework Manager.

  • A suitable webserver for example, Apache Webserver or Microsoft IIS.

  • IBM Cognos Business Intelligence Samples – any version but preferably the same version as Framework Manager.

  • SQL Server 2008 – to load the data used in Chapter 9, Model Design Accelerator, and as a suitable database for loading IBM Cognos Business Intelligence Samples.

Who this book is for

This book will be useful to all developers, both novice and expert, who use IBM Cognos Framework Manager to build packages for use by Report Studio, Query Studio, and Analysis Studio reports.

Readers are expected to have a basic understanding of reporting in IBM Cognos and are advised to get some hands-on experience of one or more Cognos studios. This book will only cover IBM Cognos Framework Manager.


In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text are shown as follows: "Common session parameters that you may see include, account.personalInfo.firstname, and account.personalInfo.surname."

A block of code is set as follows:

SELECT "product_name_lookup"."product_number" AS "PRODUCT_NUMBER",

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "Go to Start | All Programs | IBM Cognos 10 | IBM Cognos Configuration."


Warnings or important notes appear in a box like this.


Tips and tricks appear like this.

Reader feedback

Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.

To send us general feedback, simply send an e-mail to , and mention the book title via the subject of your message.

If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on

Customer support

Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.


Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from


Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.

Please contact us at with a link to the suspected pirated material.

We appreciate your help in protecting our authors, and our ability to bring you valuable content.


You can contact us at if you are having a problem with any aspect of the book, and we will do our best to address it.