Cognos
®
8
FRAMEWORK MANAGER
USER GUIDE
Product Information
This document applies to Cognos
®
8 Version 8.3 and may also apply to subsequent releases. To check for newer versions of this document,
visit the Cognos Global Customer Services Web site (http://support.cognos.com).
Copyright
Copyright © 2007 Cognos Incorporated.
Portions of Cognos® software products are protected by one or more of the following U.S. Patents: 6,609,123 B1; 6,611,838 B1; 6,662,188
B1; 6,728,697 B2; 6,741,982 B2; 6,763,520 B1; 6,768,995 B2; 6,782,378 B2; 6,847,973 B2; 6,907,428 B2; 6,853,375 B2; 6,986,135 B2;
6,995,768 B2; 7,062,479 B2; 7,072,822 B2; 7,111,007 B2; 7,130,822 B1; 7,155,398 B2; 7,171,425 B2; 7,185,016 B1;7,213,199 B2.
Cognos and the Cognos logo are trademarks of Cognos Incorporated in the United States and/or other countries. All other names are trademarks
or registered trademarks of their respective companies.
While every attempt has been made to ensure that the information in this document is accurate and complete, some typographical errors or
technical inaccuracies may exist. Cognos does not accept responsibility for any kind of loss resulting from the use of information contained
in this document.
This document shows the publication date. The information contained in this document is subject to change without notice. Any improvements
or changes to either the product or the document will be documented in subsequent editions.
U.S. Government Restricted Rights. The software and accompanying materials are provided with Restricted Rights. Use, duplication, or
disclosure by the Government is subject to the restrictions in subparagraph (C)(1)(ii) of the Rights in Technical Data and Computer Software
clause at DFARS 252.227-7013, or subparagraphs (C)(1) and (2) of the Commercial Computer Software - Restricted Rights at 48CFR52.227-19,
as applicable. The Contractor is Cognos Corporation, 15 Wayside Road, Burlington, MA 01803.
This software/documentation contains proprietary information of Cognos Incorporated. All rights are reserved. Reverse engineering of this
software is prohibited. No part of this software/documentation may be copied, photocopied, reproduced, stored in a retrieval system, transmitted
in any form or by any means, or translated into another language without the prior written consent of Cognos Incorporated.
Table of Contents
Introduction
23
Chapter 1: What’s New?
25
New Features in Version 8.3 25
Changed Features in Version 8.3 26
Deprecated Features in Version 8.3 26
Framework Manager Security Filters for SAP BW: Notice of Intent to Change the Default
Setting 26
IQD Externalize Method 27
Removed Features in Version 8.3 27
Chapter 2: Getting Started with Framework Manager
29
Analyze the Problem 29
Building Cognos 8 Applications 30
Objects You Will Use 31
Create a Project 33
Open a Project 35
The Project Page 35
The Project Viewer 35
The Explorer Tab 38
The Diagram Tab 38
The Dimension Map Tab 39
The Properties Pane 39
The Tools Pane 41
Naming Conventions for Objects in a Project 43
Sample Models 44
The Great Outdoors Warehouse Model 45
The Great Outdoors Sales Model 46
Chapter 3: Importing Metadata from Data Sources
47
Data Sources 47
Data Source Security 47
Types of Data Source Connections 48
Cognos Cubes 48
Native Metadata 50
Microsoft SQL Server Data Sources 50
Microsoft Analysis Services Data Sources 51
ODBC Data Sources 53
IBM DB2 OLAP and Hyperion Essbase Data Sources 53
Attributes of a Dimension in IBM DB2 OLAP and Hyperion Essbase Data Sources 57
Composite Software 57
XML Data Sources 57
Working With Data Source Connections 58
Create a Data Source Connection 61
User Guide 3
Recommendation - Use Network Paths for File-Based Data Sources 64
Importing Metadata 65
Import Metadata from a Relational Database 66
Import Metadata from a Cognos 8 Model 67
Import Metadata from an Architect Model or an Impromptu Catalog 68
Import Metadata from DecisionStream or Cognos 8 Data Manager 68
Import Metadata From a Third Party Metadata Source 72
Troubleshooting Metadata from Third Party Sources 76
Import Metadata Using XML as a Data Source 77
Import Objects with the Same Name 78
Chapter 4: Modeling Relational Metadata
79
Relationships 79
Cardinality 80
Modify a Relationship 83
Create a Complex Expression for a Relationship 84
Create a Relationship 84
Create a Relationship Shortcut 85
Detect and Generate Relationships 86
Query Subjects 87
Data Source Query Subjects 87
Model Query Subjects 89
Stored Procedure Query Subjects 90
Determinants 94
Create a Model Query Subject Based on Existing Objects 98
View Related Objects 99
Create a Query Set 99
Test a Query Subject or Query Set 103
Validate a Query Subject 106
Update Query Subjects 107
Convert a Query Subject into a Dimension 107
Convert a Model Query Subject into a Data Source Query Subject 108
Edit the SQL 108
Change the Type of SQL 109
Change How the SQL Is Generated 114
Dimensions 115
Normalized Data Sources 116
Create a Regular Dimension 117
Roles 123
Create a Measure Dimension 124
Convert a Measure into a Query Item 126
Scope Relationships 126
Create a Regular Dimension Based on Existing Objects 127
View Related Objects 127
Test a Dimension 128
Convert a Regular Dimension into a Query Subject 131
Multilingual Metadata 131
Setting Up a Multilingual Reporting Environment 132
Using a Macro to Model Multilingual Data 134
4 Framework Manager
Table of Contents
Add a Language to a Project 135
Export a Translation Table 136
Import a Translation Table 137
Example - Create a Multilingual Project for Relational Metadata 137
Query Items 139
Modifying How Query Items Are Aggregated 141
Format Query Items 148
Define a Prompt Control 149
Convert a Query Item into a Measure 153
Adding Business Rules 153
Create a Calculation 153
Create a Filter 156
Apply a Filter 158
Example - Show the Currency Name for Each Country 160
Create a Parameter Map 161
Example - Specifying a Language Value for Relational Metadata 162
Create a Session Parameter 163
Using Parameters with Relational Data Source Query Subjects 164
Creating Prompts with Query Macros 165
Organizing the Model 175
Create a Star Schema Group 176
Use Shortcuts 180
Create a Folder or Namespace 183
Create a Query Item Folder 184
Create a Measure Folder 185
Analyze a Model 185
Chapter 5: Working with SAP BW Metadata
191
Import from an SAP BW Data Source 191
Mapping SAP BW Objects to Framework Manager 197
Dimensions 198
Modify a Regular Dimension 199
Roles 202
Modify a Key Figures Dimension 205
Conform SAP BW Dimensions 205
View Related Objects 207
Test a Dimension or Other Object 208
Working with Model Query Subjects 211
Query Items 213
Modifying How Query Items Are Aggregated 216
Format Query Items 219
Define a Prompt Control 220
Adding Business Rules 231
Create a Calculation 231
Create a Filter 233
Apply a Filter 235
Create a Parameter Map 237
Create a Session Parameter 238
Organizing the Model 240
User Guide 5
Table of Contents