IBM Cognos 10 Framework Manager. Full of practical instructions and expert know-how, this book continues where the official manual ends, taking you from the basics into the more advanced features of IBM Cognos Framework Manager in clear, progressive steps - Ebook - Terence Phillip Curran - Nowoczesna platforma edukacyjna

Kategorie

Szczegóły ebooka

Zaloguj się, jeśli jesteś zainteresowany treścią pozycji.

IBM Cognos 10 Framework Manager. Full of practical instructions and expert know-how, this book continues where the official manual ends, taking you from the basics into the more advanced features of IBM Cognos Framework Manager in clear, progressive steps

Terence Phillip Curran

Ebook

IBM Cognos 10 Framework Manager is a complete practical guide to using and getting the best out of this essential tool for modeling your data for use with IBM Cognos Business Intelligence Reporting. With its step-by-step approach, this book is suitable for anyone from a beginner to an expert, complete with tips and tricks for better data modeling.IBM Cognos 10 Framework Manager is a step by step tutorial-based guide; from importing your data to designing and improving your model, and creating your packages while working with other modelers, every step is presented in a logical process.Learn how to use the best design strategy to design your model, create an import layer, a modeling layer, and a presentation layer to make your model easy to maintain. Do you need to design a DMR model? No problem, this book shows you every step. This book can even make working with other users easier - we will show you the methods and techniques for allowing others to work on the same model at the same time. Need to create dynamic data structures to change the way the data is presented to your users so your French users can see the data in French, your German users in German, and your English users in English? You can do all this with parameter maps.IBM Cognos 10 Framework Manager continues where the product manuals end, showing you how to build and refine your project through practical, step by step instructions.

IBM Cognos 10 Framework Manager
- Table of Contents
- IBM Cognos 10 Framework Manager
- Credits
- About the Author
- Acknowledgement
- About the Reviewer
- www.PacktPub.com
  - Support files, eBooks, discount offers and more
    - Why Subscribe?
    - Free Access for Packt account holders
    - Instant Updates on New Packt Books
- Preface
  - What this book covers
  - What you need for this book
  - Who this book is for
  - Conventions
  - Reader feedback
  - Customer support
    - Errata
    - Piracy
    - Questions
- 1. Getting Started
  - Configuring Framework Manager
  - Starting Framework Manager
  - User interface
    - The Project Viewer pane
    - The Explorer tab
    - The Diagram tab
    - The Dimension Map tab
    - The Properties pane
    - The Tools pane
    - The Summary tab
    - The Search tab
    - The Dependencies tab
    - Toolbars
  - Summary
- 2. Proven Practice
  - Modeling layers
    - Data layer
    - Logical layer
    - Presentation layer
    - Dimensional layer
  - How to create namespaces
  - How to create folders
  - Using the Model Advisor
    - How to use the Model Advisor
      - Facts identified by cardinality
    - Query subjects that can behave as facts or dimensions
    - Query subjects with multiple relationships
    - Query subjects that join to themselves
    - Determinants that conflict with relationships
    - Factors that will override the Minimized SQL setting
    - Embedded calculations that use the calculated aggregation type
    - Query subjects that can cause a metadata caching conflict
  - Summary
- 3. Importing Data Sources
  - Importing relational data
    - Importing from an existing data source
    - Importing from a new data source
  - Importing stored procedures
    - Using prompts with a stored procedure
  - Importing additional database objects
    - Importing from the same data source
      - Importing from additional data sources
  - Importing OLAP data sources
  - Combining OLAP and relational data sources
  - After importing your data sources
  - Summary
- 4. Modeling Relational Data
  - Cardinality
    - Detecting cardinality during import
    - Creating relationships and cardinality
  - Determinants
    - How to add determinants
  - Special purpose joins
    - Role playing dimensions
    - Reflexive and recursive joins
  - Where to model the relationships
  - Summary
- 5. Modeling Dimensional Data
  - Regular dimensions
    - Creating a regular dimension
  - Dimensions with multiple hierarchies
    - Creating a multiple hierarchy dimension
  - Measure dimensions
    - Creating a measure dimension
    - Creating aggregation rules for measures
  - Scope relationships
    - Creating a scope relationship
  - Summary
- 6. Creating the Business and Presentation Layers
  - Creating the business layer
    - Renaming columns
    - Hiding columns
    - Specifying attribute types
    - Adding filters
      - Embedded filters
        
        Creating an embedded filter
      - Standalone filters
        
        Creating a standalone filter
    - Adding calculations
      - Embedded calculations
        
        Creating embedded calculations
      - Standalone calculations
        
        Creating standalone calculations
    - Adding prompts
      - Creating prompts with Macros
    - Adding formatting
      - Data formatting properties
      - Using formatting patterns
      - Adding formatting
  - Creating the presentation layer
    - Grouping data items
      - Using folders and namespaces
      - Using shortcuts
        
        Creating shortcuts
  - Summary
- 7. Creating and Publishing Packages
  - Creating a package
    - Making changes to a package
  - Publishing a package
    - Using package versioning
    - Using externalized query subjects
      - Creating externalized queries
    - Using the Dynamic Query Mode
    - Using package security
  - Summary
- 8. Maintaining Projects
  - Analyzing the impact of changes made to packages
    - Analyzing publish impact
    - Showing report dependencies
    - Showing item dependencies
  - Remapping an item to a new source
    - How to remap an item
  - Reusing a project
  - Model portability
  - Moving a model by using the log file
    - How to play back actions from a log file
      - Running action logs in batch mode
      - BmtScriptPlayer syntax
  - Multiuser modeling in Framework Manager
    - Merge projects
  - Segmenting and linking projects
    - Creating a segment
      - Creating links
  - Summary
- 9. Model Design Accelerator
  - Model Design Accelerator user interface
    - Starting Model Design Accelerator
    - Adding tables to your workspace
    - Adding joins to your workspace
    - Generating a Framework Manager model
  - Summary
- 10. Parameter Maps
  - Session parameters
    - Creating a session parameter
      - Modifying session parameters
    - Using session parameters
  - Parameter maps
    - How to create parameter maps
      - Creating a parameter map manually
      - Basing a parameter map on existing query items
    - Using parameter maps
  - Summary
- A. Data Warehouse Schema Map
  - Table definitions
  - Cognos resources
    - Installed Cognos manuals
    - Resources on the Internet
- Index

Tytuł: IBM Cognos 10 Framework Manager. Full of practical instructions and expert know-how, this book continues where the official manual ends, taking you from the basics into the more advanced features of IBM Cognos Framework Manager in clear, progressive steps
Autor: Terence Phillip Curran
Tytuł oryginału: IBM Cognos 10 Framework Manager. Full of practical instructions and expert know-how, this book continues where the official manual ends, taking you from the basics into the more advanced features of IBM Cognos Framework Manager in clear, progressive steps.
ISBN: 9781849685771, 9781849685771
Data wydania: 2013-05-22
Format: Ebook
Identyfikator pozycji: e_3aus
Wydawca: Packt Publishing

wybór języka

Kategorie

Szczegóły ebooka