IBM Cognos Framework Manager Version 11.0.0 _ User Guide.pdf - IBM Cognos Framework Manager Version 11.0.0 User Guide IBM Note Before using this

IBM Cognos Framework Manager Version 11.0.0 _ User...

This preview shows page 1 out of 396 pages.

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture