IBM Cognos 10 framework manager : a comprehensive, practical guide to using this essential tool for modeling your data for use with IBM Cognos Business Intelligence Reporting / Terry Curran.

Format:

Book

Author/Creator:

Curran, Terry.

Language:

English

Subjects (All):

Business intelligence--Computer programs.

Business intelligence.

Business report writing--Computer programs.

Business report writing.

Database management--Computer programs.

Database management.

IBM software.

Physical Description:

1 online resource (186 p.)

Edition:

1st edition

Other Title:

IBM Cognos ten framework manager

Cognos 10 framework manager

Place of Publication:

Birmingham : Packt Pub., 2013.

Language Note:

English

System Details:

text file

Summary:

Full of practical instructions and expert know-how, this book continues where the official manual ends, taking you from the basics into the more advanced features of IBM Cognos Framework Manager in clear, progressive steps. Your complete and practical guide to IBM Cognos Framework Manager Full of illustrations and tips for making the best use of this essential tool, with clear step-by-step instructions and practical examples All the information you need, starting where the product manual ends In Detail "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.

Contents:

Intro

IBM Cognos 10 Framework Manager

Table of Contents

Credits

About the Author

Acknowledgement

About the Reviewer

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

1. Getting Started

Configuring Framework Manager

Starting Framework Manager

User interface

The Project Viewer pane

The Explorer tab

The Diagram tab

The Dimension Map tab

The Properties pane

The Tools pane

The Summary tab

The Search tab

The Dependencies tab

Toolbars

Summary

2. Proven Practice

Modeling layers

Data layer

Logical layer

Presentation layer

Dimensional layer

How to create namespaces

How to create folders

Using the Model Advisor

How to use the Model Advisor

Facts identified by cardinality

Query subjects that can behave as facts or dimensions

Query subjects with multiple relationships

Query subjects that join to themselves

Determinants that conflict with relationships

Factors that will override the Minimized SQL setting

Embedded calculations that use the calculated aggregation type

Query subjects that can cause a metadata caching conflict

3. Importing Data Sources

Importing relational data

Importing from an existing data source

Importing from a new data source

Importing stored procedures

Using prompts with a stored procedure

Importing additional database objects

Importing from the same data source

Importing from additional data sources

Importing OLAP data sources.

Combining OLAP and relational data sources

After importing your data sources

4. Modeling Relational Data

Cardinality

Detecting cardinality during import

Creating relationships and cardinality

Determinants

How to add determinants

Special purpose joins

Role playing dimensions

Reflexive and recursive joins

Where to model the relationships

5. Modeling Dimensional Data

Regular dimensions

Creating a regular dimension

Dimensions with multiple hierarchies

Creating a multiple hierarchy dimension

Measure dimensions

Creating a measure dimension

Creating aggregation rules for measures

Scope relationships

Creating a scope relationship

6. Creating the Business and Presentation Layers

Creating the business layer

Renaming columns

Hiding columns

Specifying attribute types

Adding filters

Embedded filters

Creating an embedded filter

Standalone filters

Creating a standalone filter

Adding calculations

Embedded calculations

Creating embedded calculations

Standalone calculations

Creating standalone calculations

Adding prompts

Creating prompts with Macros

Adding formatting

Data formatting properties

Using formatting patterns

Creating the presentation layer

Grouping data items

Using folders and namespaces

Using shortcuts

Creating shortcuts

7. Creating and Publishing Packages

Creating a package

Making changes to a package

Publishing a package

Using package versioning

Using externalized query subjects

Creating externalized queries

Using the Dynamic Query Mode

Using package security

8. Maintaining Projects

Analyzing the impact of changes made to packages

Analyzing publish impact

Showing report dependencies.

Showing item dependencies

Remapping an item to a new source

How to remap an item

Reusing a project

Model portability

Moving a model by using the log file

How to play back actions from a log file

Running action logs in batch mode

BmtScriptPlayer syntax

Multiuser modeling in Framework Manager

Merge projects

Segmenting and linking projects

Creating a segment

Creating links

9. Model Design Accelerator

Model Design Accelerator user interface

Starting Model Design Accelerator

Adding tables to your workspace

Adding joins to your workspace

Generating a Framework Manager model

10. Parameter Maps

Session parameters

Creating a session parameter

Modifying session parameters

Using session parameters

Parameter maps

How to create parameter maps

Creating a parameter map manually

Basing a parameter map on existing query items

Using parameter maps

A. Data Warehouse Schema Map

Table definitions

Cognos resources

Installed Cognos manuals

Resources on the Internet

Index.

Notes:

"Professional expertise distilled"--Cover.

Includes index.

ISBN:

9781849685771

1849685770

OCLC:

849919023