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
Credits
About the Author
Acknowledgement
About the Reviewer
www.PacktPub.com
Preface
Index

Importing relational data


To start the import of your relational database metadata into your Framework Manager project, carry out the following steps:

  1. Start the Framework Manager, and choose Create a new project:

  2. Give your project a name, choose the location where the project model will be stored, and then click on the OK button.

    Note

    IBM Cognos now recommends that all new Framework Manager models use the Dynamic Query Mode for all data sources.

  3. At the bottom left of this dialog screen, there is a checkbox labeled Use Dynamic Query Mode. If you want to turn on the Dynamic Query Mode for your model, then check this box; otherwise leave the box unchecked.

    Tip

    It is not necessary to select Dynamic Query Mode at this stage as it may also be selected later when your package is published.

  4. Choose your language for the project, and then click on the OK button:

  5. Choose the metadata source for the project and then click on the Next > button:

  6. By default, the Framework Manager will choose Data Sources, which...