O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

IBM Cognos Business Intelligence

IBM Cognos Business Intelligence

by Dustin Adkison
Publisher: Packt Publishing
Release Date: May 2013
ISBN: 9781849683562
View table of contents
Start reading

Book Description

Discover the practical approach to BI with IBM Cognos Business Intelligence

  • Learn how to better administer your IBM Cognos 10 environment in order to improve productivity and efficiency.
  • Empower your business with the latest Business Intelligence (BI) tools.
  • Discover advanced tools and knowledge that can greatly improve daily tasks and analysis.
  • Explore the new interfaces of IBM Cognos 10.

In Detail

IBM Cognos is Business Intelligence software that enables businesses to fully utilize their maximum potential. It connects people with information from virtually any data source whenever and wherever they need it so that they can make better decisions, faster.

Take the practical, hands-on approach to managing your reporting environment with "IBM Cognos Business Intelligence" - packed with coverage of all the latest features to truly help you maximize your potential.

With this in-depth practical guide you will learn how to fully utilize IBM Cognos 10 so that your business can make smarter decisions, achieve better results and gain a deeper understanding of your company’s data. You will learn about critical topics like Report Studio, Query Studio, Analysis Studio, Security and Administration as well as in-depth coverage of other features like Business Insight, Business Insight Advanced, and Active Reports, which were introduced with IBM Cognos 10.

Table of Contents

  1. IBM Cognos Business Intelligence
    1. Table of Contents
    2. IBM Cognos Business Intelligence
    3. Credits
    4. Foreword
    5. About the Author
    6. Acknowledgement
    7. About the Reviewers
    8. www.PacktPub.com
      1. Support files, eBooks, discount offers and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
        3. Instant Updates on New Packt Books
    9. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Errata
        2. Piracy
        3. Questions
    10. 1. IBM Cognos Connection
      1. Web-based reporting
      2. The welcome page
      3. Folder structures
      4. My Area
      5. Searching
      6. Running reports
      7. Scheduling reports
      8. Cutting, copying, pasting, and deleting objects
      9. Creating URLs, jobs, and report views
      10. The business case for Cognos
      11. Summary
    11. 2. Introducing IBM Cognos Workspace
      1. The self-service dashboard
      2. Adding content and content types
      3. Filtering
      4. Changing the formatting
      5. Sharing the dashboard
      6. The business case for Cognos Workspace
      7. Summary
    12. 3. IBM Cognos Active Reports
      1. What MHT files are
      2. How MHT files can be read
      3. Pros and cons
        1. Pros
        2. Cons
      4. The business case for Cognos Active Reports
      5. Interacting with Cognos Active Reports
        1. Opening Cognos Active Reports
        2. Navigating through Cognos Active Reports
      6. Summary
    13. 4. IBM Cognos Mobile
      1. Cognos Mobile on BlackBerry phones
      2. New features of IBM Cognos Mobile
      3. Interacting with Cognos Active Reports on mobile devices
      4. The future of IBM Cognos Mobile
      5. The business case for IBM Cognos Mobile
      6. Summary
    14. 5. IBM Cognos Query Studio
      1. Who should use Cognos Query Studio?
      2. Accessing Cognos Query Studio
      3. An introduction to metadata
      4. The drag-and-drop interface and the right-click menu
        1. Inserting content in a report
        2. Adding filters
        3. Creating a calculation
        4. Formatting your report
        5. Incorporating charts
        6. Understanding your other buttons
      5. Saving and sharing reports
      6. The business case for Cognos Query Studio
      7. Summary
    15. 6. IBM Cognos Analysis Studio
      1. Who should use Cognos Analysis Studio?
      2. Accessing Cognos Analysis Studio
      3. An introduction to multidimensional data
      4. Exploring the drag-and-drop interface and the right-click menu
        1. Inserting dimensions and measures
        2. Adding context filters
        3. Drilling down and expanding data
          1. Replacing the existing dimension
          2. Nesting within the existing dimension
          3. Nesting below an existing dimension
        4. Creating calculations
        5. Incorporating charts
          1. Choosing a chart type
        6. Understanding the other buttons
      5. Saving and sharing Cognos Analysis Studio reports
      6. The business case for Cognos Analysis Studio
      7. Summary
    16. 7. IBM Cognos Workspace Advanced
      1. Who should use Cognos Workspace Advanced?
      2. Comparing to Cognos Query Studio and Cognos Analysis Studio
      3. Accessing Cognos Workspace Advanced
      4. Exploring the drag-and-drop interface and the right-click menu
        1. Adding objects to your report
        2. Adding data to your reports
        3. Drilling down
        4. Creating calculations
        5. Understanding the other buttons
      5. Using external data
      6. The business case for Cognos Workspace Advanced
      7. Summary
    17. 8. IBM Cognos Report Studio
      1. Who should use Cognos Report Studio
      2. Accessing Cognos Report Studio
      3. Cognos Report Studio report types
      4. The drag-and-drop interface and the right-click menu
        1. Understanding the different areas in Cognos Report Studio
        2. Adding objects to your report
        3. Adding data to your reports and formatting
        4. Exploring your queries with Query Explorer
        5. Setting up conditions
        6. Adding a prompt to filter results
        7. Understanding the other buttons
      5. Building Active Reports
        1. Designing your Active Report
        2. Choosing the Active Report component to use
      6. The business case for Cognos Report Studio
        1. Reporting inside of the organization
        2. Reporting outside of the organization
      7. Summary
    18. 9. IBM Cognos Framework Manager
      1. Introduction to metadata
      2. Managing the model design project
        1. Rule 1 – gather information
        2. Rule 2 – learn to dance
        3. Rule 3 – take baby steps
        4. Rule 4 – know your audience
        5. Rule 5 – get buy-in and sign off
      3. Three-tier approach to model design
      4. Designing a database view of your data
      5. Designing a business view of your data
      6. Designing an end user view of your data
      7. Publishing a package
      8. The business case for Cognos Framework Manager
        1. Understanding the problem
        2. Understanding the solution
      9. Summary
    19. 10. Administration and Performance Tuning
      1. Deciding who should be an administrator
      2. Navigating the administration interface
      3. Monitoring the system in the Status tab
      4. Performance tuning the system
      5. Designing your security model
        1. The CAF
        2. External security
        3. Cognos BI security
        4. Capabilities
        5. How it all works together
          1. What people can do
          2. What people can see
      6. Adding data source connections
      7. Importing and exporting content
      8. Routing your requests using routing sets
      9. The business case for performance tuning
      10. The business case for administration
      11. Summary
    20. 11. Streamlining Common Administrator Tasks
      1. Bulk updating Framework Manager models
      2. Validating report objects
      3. Bulk updating reports
      4. Applying screen tips to report outputs
      5. Managing security
      6. Distributing portal tabs
      7. Standardizing headers and footers
      8. Backing up, restoring, and deploying content
      9. Documenting content, security, and models
        1. Content Documentation
        2. Security Documentation
        3. Model documentation
      10. Versioning content
      11. Archiving content outputs
      12. Retrieving deleted content
      13. The business case for add-on tools
      14. Summary
    21. 12. User Adoption
      1. The beginning – executive sponsorship
      2. Building an internal user community
      3. The right development team matters
      4. How to partner with IBM and the partner community
      5. Feedback and its role in the development process
      6. Training is the key to success
      7. The business case user adoption
      8. Summary
    22. Index