To Next Page

To Previous Page

Contents

Introduction .................................xiii

Chapter 1. What's New? .............................1

New Features in Version 10.1.1 .............................1

New Features in Version 10.1.0 .............................1

Publishing Cube Groups ..............................1

Deprecated Features in Version 10.1.0 ...........................1

Removed Features in Version 10.1.0............................1

PowerCube Connection (PCConn) Utility .........................1

Framework Manager Externalized Queries ........................2

Chapter 2. Planning Your Model .........................3

Dimensional Modeling Workflow ............................3

Analyzing Your Requirements and Source Data.......................4

Preprocessing Your Data ..............................4

Building a Prototype................................6

Refining Your Model ...............................8

Diagnose and Resolve Any Design Problems .......................9

Upgrade an IBM Cognos Series 7 Model..........................11

Chapter 3. Data Sources for Your Model .....................13

Techniques for Designing Data Sources ..........................13

Data Source Types .................................13

IBM Cognos Package or Report............................14

Business Viewpoint Studio .............................18

IBM InfoSphere Warehouse Cubing Services .......................18

TM1 Cubes ..................................19

Impromptu Query Definition File ...........................19

Delimited-field Text with Column Titles .........................19

Delimited-field Text ...............................19

Access Table ..................................20

Access Query ..................................20

Excel Crosstab .................................20

Excel Database .................................20

PowerHouse Portable Subfile ............................21

Fixed-field Text .................................21

Fixed Field and Record Without CR LF .........................21

Designing Successful IBM Cognos PowerCubes .......................21

Conformed Dimensions ..............................21

IBM Cognos Business Keys .............................22

Member Unique Names ..............................22

Resolving Uniqueness Problems in Your Data Source ....................23

Creating a Model .................................24

Creating a Model Using an IBM Cognos Package or Report ..................25

Creating a Model Using an SAP BW Package .......................27

Creating a Model Using Other Data Sources .......................28

Edit Existing Prompts in IBM Cognos Reports and Packages ...................29

Generate a File of Prompt Values for Use in the Command Line.................31

Remove Obsolete Prompts .............................31

Specifying a Segmenting Prompt for an SAP BW Query ....................32

Change a Data Source Type ..............................33

Create Dimensions from the Dimension Map Using OLAP and DMR Packages .............33

Adding an IBM Cognos Data Source to an Existing Model ...................34

Add Additional Queries to Existing IBM Cognos Data Sources .................35

Adding Other Data Sources to an Existing Model.......................36

Developer	IBM
Data Source	flat files
Operating System	Microsoft Windows
License	Commercial
Input Sources	SQL databases, Excel, CSV
Platform	Microsoft Windows

IBM Cognos User Manual

Table of Contents

Questions and Answers:

IBM Cognos Specifications