IBM Cognos Framework Manager Version 10.1.1: User Guide Ug Fm

User Manual: Pdf

Open the PDF directly: View PDF .
Page Count: 619 [warning: Documents this large are best viewed by clicking the View PDF Link!]

Scroll down to view the document on your mobile browser.

Contents
Introduction
Chapter 1. What's new?
- New features in 10.1.1
- Changed features in 10.1.1
- Deprecated features in 10.1.1
- Removed features in 10.1.0
- New features in 10.1.0
- Changed features in 10.1.0
- Deprecated features in 10.1.0
- Removed features in 10.1.0
- New features in 8.4
- Changed features in 8.4
- Deprecated features in version 8.4
- New features in version 8.3
- Changed features in version 8.3
- Deprecated features in version 8.3
  - Framework Manager security filters for SAP BW: notice of intent to change the default setting
  - IQD externalize method
- Removed features in version 8.3
Chapter 2. Getting started with Framework Manager
- Analyzing the problem
- Building IBM Cognos Business Intelligence Applications
- Objects you will use
- Creating projects
- Opening projects
- The project page
- Naming conventions for objects in a project
- Sample models
  - The Great Outdoors Warehouse model
  - The Great Outdoors Sales model
Chapter 3. Model Design Accelerator
- Explorer tree
- Explorer diagram
- The Model Accelerator workspace
- Changing the settings for diagrams
- Creating a project
- The star schema
- Managing your star schema
Chapter 4. Importing metadata from data sources
- Data sources
- Data source security
- Types of data source connections
  - Native metadata
- Data source connections
- Creating data source connections
  - Steps to create a data source connection
- Importing metadata
Chapter 5. Modeling relational metadata
- Setting up the import view
- Setting up the business view
- Relationships
- Query subjects
- Dimensions
- Multilingual metadata
- Query items
- Business rules
- Organizing models
- Durable models
  - Creating a durable model
  - Testing a durable model
- Analyzing models
  - Steps to analyze a model
Chapter 6. SAP BW metadata
- Import from an SAP BW data source
- Mapping SAP BW objects to Framework Manager
- Dimensions (SAP BW)
- Query items (SAP BW)
- Adding business rules (SAP BW)
- Organizing the model (SAP BW)
  - Shortcuts (SAP BW)
  - Creating folders or namespaces (SAP BW)
    - Steps to create a folder
    - Steps to create a namespace
Chapter 7. Publishing packages
- Verifying models or packages
- Creating or modifying packages
  - Creating a package
  - Modifying a package
- Security
- Specifying languages
  - Specifying languages for one package
  - Specifying languages for all packages
- Setting suppression options
- Externalized query subjects and dimensions
- Publishing packages
Chapter 8. Project management
- Metadata in your model
- Multiuser modeling
- Metadata administration
- Synchronizing projects
  - Steps to synchronize
- Query behavior
Chapter 9. Guidelines for Modeling Metadata
- Understanding IBM Cognos Modeling Concepts
- Building the Relational Model
Chapter 10. The SQL Generated by IBM Cognos Software
- Understanding Dimensional Queries
- Resolving Ambiguously Identified Dimensions and Facts
  - Query Subjects That Represent a Level of Hierarchy
  - Resolving Queries That Should Not Have Been Split
Chapter 11. Upgrading models
- Verifying the models before upgrading
- Opening and upgrading the models
- Verifying and repairing the upgraded IBM Cognos ReportNet models
  - Converting dimension information to either determinants or dimensions
    - Dimension information mapping
    - Post-conversion review
  - Selecting and repairing objects in the upgraded IBM Cognos ReportNet models
- Upgrading segmented and linked projects
Appendix A. Troubleshooting
- Unable to Compare Two CLOBs in Oracle
- An Out of Memory Error with ERWin Imported Metadata
- Framework Manager Cannot Access the Gateway URI
- Object Names Appear in the Wrong Language
- Full Outer Joins in Oracle Return Incorrect Results
- Error When Testing Query Subjects in a Model Imported from Teradata
- Error for Type-In SQL Query Subject
- QE-DEF-0259 Error
- Externalized Key Figures Dimension Retains Old Prompt Value
- Older Models Display Level Object Security
- Exporting a Framework Manager Model to a CWM File Fails With Error MILOG.TXT was not found
- Difference in SQL for Inner Joins After Upgrading to IBM Cognos BI, Version 8.3 and Later
- Full Outer Joins Not Sent to Oracle 9i and 10GR1
- Unexplained Discrepancies in Number Calculations
Appendix B. Using the expression editor
- Searching for values may return unexpected results
- Calculation components
Appendix C. Accessibility features
- Accessibility features in Framework Manager
- Keyboard shortcuts for Framework Manager
  - Keyboard shortcuts for Model Design Accelerator
- IBM and accessibility
Appendix D. Data formatting reference
- Data Formatting Properties
Appendix E. Using Patterns to Format Data
- Pattern Guidelines
- Date and Time Symbols
- Decimal Format Symbols
Appendix F. Guidelines for Working with SAP BW Data for Use in Transformer
- Working with SAP BW Data Using a Package in Framework Manager
- Working with SAP BW Data Using Externalized CSV Files in Framework Manager
Appendix G. Reserved words
Appendix H. XML data types
Notices
Glossary
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- W
Index
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X

Navigation menu