IBM Cognos 10 Framework Manager


IBM Cognos 10 Framework Manager
eBook: $20.99
Formats: PDF, PacktLib, ePub and Mobi formats
$17.84
save 15%!
Print + free eBook + free PacktLib access to the book: $55.98    Print cover: $34.99
$34.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Your complete and practical guide to IBM Cognos Framework Manager
  • Full of illustrations and tips for making the best use of this essential tool, with clear step-by-step instructions and practical examples
  • All the information you need, starting where the product manual ends

Book Details

Language : English
Paperback : 186 pages [ 235mm x 191mm ]
Release Date : May 2013
ISBN : 1849685762
ISBN 13 : 9781849685764
Author(s) : Terry Curran
Topics and Technologies : All Books, Enterprise Products and Platforms, Enterprise, IBM

Table of Contents

Preface
Chapter 1: Getting Started
Chapter 2: Proven Practice
Chapter 3: Importing Data Sources
Chapter 4: Modeling Relational Data
Chapter 5: Modeling Dimensional Data
Chapter 6: Creating the Business and Presentation Layers
Chapter 7: Creating and Publishing Packages
Chapter 8: Maintaining Projects
Chapter 9: Model Design Accelerator
Chapter 10: Parameter Maps
Appendix: Data Warehouse Schema Map
Index
  • Chapter 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
    • Chapter 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
      • Chapter 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
        • Chapter 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
          • Chapter 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
            • Chapter 6: Creating the Business and Presentation Layers
              • Creating the business layer
                • Renaming columns
                • Hiding columns
                • Specifying attribute types
                • Adding filters
                  • Embedded filters
                  • Standalone filters
                • Adding calculations
                  • Embedded calculations
                  • 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
              • Summary
              • Chapter 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
                • Chapter 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
                  • Chapter 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
                    • Chapter 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

                        Terry Curran

                        Terry Curran gained an interest in computers while studying for his first degree in Biological Chemistry at the University of Kent. He went on to work as a computer operator for a national supermarket company. After working for several years as a computer operator, he went to Brighton Polytechnic, leaving with a Higher National Diploma in Computer Studies. Upon completion of his studies, he worked as a computer advisor at the City of London Polytechnic, assisting staff and students with their computer problems, and providing support for the various database systems in use across the Polytechnic. After taking voluntary redundancy from this post, he proceeded to the University of Stirling where he gained an MSc in Software Engineering. After graduating from the University of Stirling, Terry commenced working for a software consultancy company. While working for this company, Terry assisted with the writing of a software package for the publishing industry using Cognos PowerHouse. While working for this company, Terry gained experience in Business Intelligence Reporting tools, being asked to familiarize himself with Cognos Impromptu and PowerPlay in order to promote the use of these tools to clients. After this company ceased trading, Terry embarked on a career as a freelance computer consultant and contractor, using his experience with Cognos PowerHouse, various computer systems and databases, and Cognos Impromptu and PowerPlay, and later Cognos 8 and Cognos 10. Terry continues to work as a freelance Cognos Business Intelligence consultant and contractor, making use of his extensive knowledge and experience of IBM Cognos Business Intelligence Reporting. During the past 15 years, Terry has worked for a range of different industries including aviation, pharmaceuticals, insurance, logistics, and manufacturing to name a few. Terry is currently working for Ultra Electronics Command and Control Systems as a freelance Cognos consultant. Terry Curran was a technical reviewer for the book IBM Cognos 8 Report Studio Cookbook, Packt Publishing.
                        Sorry, we don't have any reviews for this title yet.

                        Submit Errata

                        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                        Sample chapters

                        You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                        Frequently bought together

                        IBM Cognos 10 Framework Manager +    IBM Cognos 10 Report Studio Cookbook, Second Edition =
                        50% Off
                        the second eBook
                        Price for both: $38.55

                        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                        What you will learn from this book

                        • Learn how to import and model your relational data
                        • Create useful reporting packages for your authors
                        • Utilise parameters and parameter reports effectively
                        • Improve functionality and manage a multi-user model
                        • Learn how to use Model Design Accelerator to create your first model

                        In Detail

                        "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.

                        Approach

                        Presented in a hands-on style, this guide presents you with real world examples to guide you through every process step by step.

                        Who this book is for

                        This book will be useful for any developer, novice or expert, who uses Framework Manager to build packages, but wants to expand their knowledge even further.

                        Code Download and Errata
                        Packt Anytime, Anywhere
                        Register Books
                        Print Upgrades
                        eBook Downloads
                        Video Support
                        Contact Us
                        Awards Voting Nominations Previous Winners
                        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                        Resources
                        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software