You've reached the end of your free preview.
Want to read all 396 pages?
Unformatted text preview: IBM Cognos Framework Manager
Version 11.0.0 User Guide IBM Note
Before using this information and the product it supports, read the information in “Notices” on page
369. Product Information
This document applies to IBM Cognos Analytics Version 11.0.0 and may also apply to subsequent releases.
Licensed Materials - Property of IBM
© Copyright International Business Machines Corporation 2005, 2016. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with
IBM Corp. Contents
Introduction......................................................................................................... ix
Chapter 1. What's new ..........................................................................................1
Changed features in 11.0.4......................................................................................................................... 1 Chapter 2. Getting started with Framework Manager.............................................. 3 Analyzing the problem................................................................................................................................. 3
Building IBM Cognos Analytics applications...............................................................................................4
Objects you will use..................................................................................................................................... 5
Creating projects ......................................................................................................................................... 7
Opening projects.......................................................................................................................................... 8
The project page.......................................................................................................................................... 9
The Project Viewer..................................................................................................................................9
Changing options for projects.............................................................................................................. 12
Reordering objects............................................................................................................................... 13
The Explorer tab................................................................................................................................... 13
The Diagram tab................................................................................................................................... 13
The Dimension Map tab....................................................................................................................... 14
The Properties pane............................................................................................................................. 14
The Tools pane..................................................................................................................................... 16
Naming conventions for objects in a project.............................................................................................17
Sample models.......................................................................................................................................... 19
The Great Outdoors Warehouse model............................................................................................... 19
The Great Outdoors Sales model.........................................................................................................20 Chapter 3. Model Design Accelerator....................................................................21 Explorer tree.............................................................................................................................................. 21
Explorer diagram........................................................................................................................................22
The Model Accelerator workspace............................................................................................................22
Query Subject Diagram........................................................................................................................ 23
Using the Relationship Editing Mode................................................................................................... 23
Model Warning view............................................................................................................................. 24
Changing the settings for diagrams...........................................................................................................24
Creating a project ......................................................................................................................................24
The star schema.........................................................................................................................................25
Managing your star schema.......................................................................................................................26 Chapter 4. Importing metadata from data sources................................................29
Data sources.............................................................................................................................................. 29
Data source security.................................................................................................................................. 29
Native metadata.........................................................................................................................................30
Data source connections........................................................................................................................... 30
Creating a data source connection...................................................................................................... 33
Importing metadata...................................................................................................................................34
Importing metadata from relational databases.................................................................................. 35
Importing metadata from IBM Cognos models...................................................................................38
Importing metadata from Architect models or Impromptu catalogs.................................................39
Importing metadata from IBM Cognos DecisionStream or IBM Cognos Data Manager.................... 39
Importing metadata from third party metadata sources.................................................................... 42
Troubleshooting metadata from other sources.................................................................................. 50
iii Importing metadata using XML as a data source................................................................................51
Importing objects with the same name...............................................................................................52 Chapter 5. Modeling relational metadata..............................................................53 Setting up the import view.........................................................................................................................53
Setting up the business view..................................................................................................................... 53
Relationships............................................................................................................................................. 54
Cardinality.............................................................................................................................................54
Modifying a relationship....................................................................................................................... 57
Creating complex expressions for a relationship................................................................................ 57
Creating relationships ......................................................................................................................... 58
Creating a relationship shortcut ..........................................................................................................58
Detecting and generating relationships ..............................................................................................59
Bridge tables........................................................................................................................................ 59
Query subjects........................................................................................................................................... 62
Data source query subjects..................................................................................................................63
Model query subjects........................................................................................................................... 64
Stored procedure query subjects........................................................................................................ 65
Determinants........................................................................................................................................69
Creating model query subjects based on existing objects..................................................................72
Viewing related objects........................................................................................................................72
Creating query sets.............................................................................................................................. 73
Testing query subjects or query sets...................................................................................................75
Validating query subjects..................................................................................................................... 78
Updating query subjects...................................................................................................................... 79
Converting query subjects into dimensions........................................................................................ 79
Converting model query subjects into data source query subjects....................................................80
Editing the SQL..................................................................................................................................... 80
Changing the type of SQL..................................................................................................................... 81
Changing how the SQL is generated.................................................................................................... 86
Dimensions................................................................................................................................................ 87
Normalized data sources..................................................................................................................... 87
Creating regular dimensions................................................................................................................ 88
Sorting members of a level.................................................................................................................. 93
Roles..................................................................................................................................................... 94
Creating measure dimensions............................................................................................................. 96
Converting measures into query items................................................................................................97
Scope relationships..............................................................................................................................97
Creating regular dimensions based on existing objects..................................................................... 98
Viewing related objects........................................................................................................................98
Testing dimensions.............................................................................................................................. 99
Converting regular dimensions into query subjects..........................................................................101
Multilingual metadata..............................................................................................................................101
Supporting multilingual metadata..................................................................................................... 102
Setting up a Multilingual Reporting Environment............................................................................. 102
Modeling with multilingual data sources...........................................................................................103
Using macros to model multilingual data..........................................................................................104
Adding a language to a project.......................................................................................................... 104
Exporting translation tables...............................................................................................................105
Importing translation tables.............................................................................................................. 105
Example - create multilingual projects for relational metadata.......................................................106
Query items..............................................................................................................................................107
Modifying how query items are aggregated...................................................................................... 110
Formatting query items......................................................................................................................117
Defining prompt controls................................................................................................................... 118
Converting query items into measures..............................................................................................122
Business rules..........................................................................................................................................122 iv Creating calculations..........................................................................................................................123
Creating filters....................................................................................................................................125
Applying filters................................................................................................................................... 127
Example - showing the currency name for each country................................................................. 128
Creating parameter maps ................................................................................................................. 129
Example - Specifying language values for relational metadata....................................................... 130
Creating session parameters............................................................................................................. 131
Using parameters with relational data source query subjects......................................................... 132
Creating prompts with query macros................................................................................................ 133
Organizing models................................................................................................................................... 142
Creating star schema groups............................................................................................................. 143
Shortcuts............................................................................................................................................ 147
Creating folders or namespaces........................................................................................................ 149
Creating query item folders............................................................................................................... 150
Creating measure folders...................................................................................................................151
Durable models........................................................................................................................................151
Creating a durable model...................................................................................................................152
Testing a durable model.................................................................................................................... 153
Analyzing models.....................................................................................................................................153
Steps to analyze a model................................................................................................................... 157 Chapter 6. SAP BW metadata.............................................................................159 Import from an SAP BW data source...................................................................................................... 159
Access to SAP BW metadata and data.............................................................................................. 159
SAP BW structures............................................................................................................................. 161
SAP BW hierarchies............................................................................................................................161
Steps to access a secured InfoCube................................................................................................. 162
Steps to import from an SAP BW data source...................................................................................163
Mapping SAP BW objects to Framework Manager................................................................................. 164
Dimensions (SAP BW)..............................................................................................................................165
Modifying a regular dimension (SAP BW).......................................................................................... 165
Roles (SAP BW).................................................................................................................................. 171
Modifying a key figures dimension (SAP BW)....................................................................................172
Viewing related objects (SAP BW)..................................................................................................... 173
Testing a dimension or other object (SAP BW)................................................................................. 173
Model query subjects (SAP BW)........................................................................................................ 176
Query items (SAP BW)............................................................................................................................. 177
Modifying how query items are agg...
View
Full Document
- Fall '19
- Data Management, IBM Corp.
