You are previewing SAP BusinessObjects Reporting Cookbook.
O'Reilly logo
SAP BusinessObjects Reporting Cookbook

Book Description

Over 80 recipes to help you build, customize, and distribute reports using SAP BusinessObjects

In Detail

This book will educate you on the best practices in SAP BusinessObjects reporting and analysis, including how to create enhanced report formatting and synchronize data sources in simple and easy ways.

The book starts by introducing a working Web Intelligence environment and its capabilities. Next, it moves on to creating queries, working with the formatting components, and explaining how to work with different types of data presentation such as tables and charts. The book then guides you through the main report functionality such as using filters, sorts, and calculations; merging data; and using formulas. The book also explains how to work with advanced features such as drills and hyperlinks.

This book will take you from the most basic level of how to build a query and elementary concepts such as the nature of data to the most advanced and updated reporting and formatting techniques.

What You Will Learn

  • Master advanced report building techniques using SAP BusinessObjects
  • Discover tools to work efficiently in a BI environment
  • Learn using real scenarios, varied examples, and systematic execution of the solutions
  • Build variables and formulas to enhance the report calculation functionality such as if-then statements
  • Use drill-down and drill-through tasks to perform detailed analysis
  • Filter data using simple and advanced filters and advanced features such as input controls
  • Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

    Table of Contents

    1. SAP BusinessObjects Reporting Cookbook
      1. Table of Contents
      2. SAP BusinessObjects Reporting Cookbook
      3. Credits
      4. About the Author
      5. About the Reviewers
      6. 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
      7. 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
      8. 1. Working with the BI Launch Pad
        1. Introduction
        2. Connecting to the BI launch pad
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        3. Navigating within the BI launch pad
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        4. Using the BI launch pad toolbars
          1. How to do it...
          2. How it works...
          3. See also
        5. Adjusting the preferences
          1. How to do it...
          2. How it works...
          3. See also
        6. Searching documents
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Launching applications
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        8. The report menu functionality
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        9. Working with different objects of the BI launch pad
          1. Getting ready
          2. How to do it...
          3. How it works...
      9. 2. Creating New Queries
        1. Introduction
        2. The universe structure
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also
        3. Creating a simple query
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
          5. There's more...
        4. Editing the query
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Filtering the query results
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Using prompts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        7. Using AND/OR logic in conditions
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        8. Creating nested filters
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        9. Using a subquery
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        10. Using combined queries
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        11. Adding another query
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        12. Working with several queries
          1. How to do it...
          2. There's more...
          3. See also
        13. Working with the query properties
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        14. Using the data preview
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There is more
          5. See also
        15. Viewing the SQL
          1. How to do it...
          2. How it works...
          3. There's more...
        16. Using other query results
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        17. Scope of analysis
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        18. Using database ranking
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        19. Using BEx queries
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      10. 3. Working Inside the Report
        1. Introduction
        2. Understanding the structure of the Report layer
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Understanding the concept of the microcube
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        4. Working with the Left Pane panels
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        5. Working with the report toolbars
          1. Getting ready
          2. How to do it...
          3. How it works...
        6. Navigating between the view modes
          1. How to do it...
          2. How it works...
        7. The File and Properties tabs
          1. How to do it...
          2. How it works...
      11. 4. Working with Tables
        1. Introduction
        2. Getting to know the structure of tables
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        3. Working with different types of tables
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        4. Formatting tables
          1. Getting ready
          2. How to do it...
          3. How it works...
        5. Working with cross tables
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        6. Hiding dimensions
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      12. 5. Working with Charts
        1. Introduction
        2. Working with the Line chart
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        3. Working with different chart types
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        4. Formatting charts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's moreā€¦
      13. 6. Formatting Reports
        1. Introduction
        2. Using sorts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Using calculations
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also
        4. Using sections and breaks
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Ranking
          1. How to do it...
          2. How it works...
          3. There's more...
          4. See also
        6. Conditional rules
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        7. Data tracking
          1. Getting ready
          2. How to do it...
          3. How it works...
        8. Outline and fold
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      14. 7. Filtering the Report Data
        1. Introduction
        2. Applying a simple filter
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Working with the filter bar
          1. Getting ready
          2. How to do it....
          3. How it works...
          4. There's more...
        4. Using input controls
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Working with an element link
          1. How to do it...
          2. How it works...
          3. There's more...
      15. 8. Merging Data
        1. Introduction
        2. Merging data from several queries
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        3. Understanding the merge logic
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        4. Merging data from different universes
          1. How to do it...
          2. How it works...
          3. There's more...
        5. Merging data from different data sources
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        6. Filtering matched values
          1. Getting ready
          2. How to do it...
          3. How it works...
        7. Troubleshooting aggregation problems
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        8. Extending the data synchronization
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      16. 9. Using Formulas and Variables
        1. Introduction
        2. Using formulas
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        3. Working with variables
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        4. Using aggregate functions
          1. How to do it...
          2. How it works...
          3. See also
        5. Using character functions
          1. How to do it...
          2. How it works...
        6. Using data provider functions
          1. How to do it...
          2. How it works...
        7. Using date and time functions
          1. How to do it...
          2. How it works...
        8. Using document functions
          1. How to do it...
          2. How it works...
          3. There's more...
        9. Using logical functions
          1. How to do it...
          2. How it works...
        10. Using misc functions
          1. How to do it...
          2. How it works...
        11. Using numeric functions
          1. How to do it...
          2. How it works...
        12. Using extended syntax
          1. How to do it...
          2. How it works...
          3. There's more...
      17. 10. Using Hyperlinks
        1. Introduction
        2. Connecting reports
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        3. Passing parameters between reports
          1. Getting ready
          2. How to do it...
          3. How it works...
        4. Linking to a web page
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
        5. Creating and editing hyperlinks manually
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. See also
      18. 11. Using Drill
        1. Introduction
        2. Using the scope of analysis
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Using a query drill
          1. Getting ready
          2. How to do it...
        4. Using the drill formula
          1. Getting ready
          2. How to do it...
          3. See also
      19. 12. Scheduling Reports
        1. Introduction
        2. Scheduling a report
          1. Getting ready
          2. How to do it...
          3. How it works...
        3. Working with instance history
          1. Getting ready
          2. How to do it...
          3. How it works...
        4. Publications
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        5. Advanced publication options
          1. Getting ready
          2. How to do it...
      20. 13. Working with BI Workspaces
        1. Introduction
        2. Creating BI workspaces
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Working with report parts
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
      21. 14. Web Intelligence Rich Client
        1. Introduction
        2. Working with Web Intelligence Rich Client
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
        3. Working with local data providers
          1. Getting ready
          2. How to do it...
          3. How it works...
          4. There's more...
          5. See also
        4. Adjusting options
          1. Getting ready
          2. How to do it...
          3. See also
      22. Index