Book Image

SAP BusinessObjects Reporting Cookbook

By : Yoav Yohav
Book Image

SAP BusinessObjects Reporting Cookbook

By: Yoav Yohav

Overview of this book

Related Content you might be interested in

Current Title:

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

Using numeric functions

Numeric functions can be used to perform mathematical calculations and common calculations such as rounding and ranking.

The main numeric functions are as follows:

  • Abs: This returns the absolute value of the number (this is useful if we have negative values that we need to display as positive)

  • Ceil: This rounds up a number

  • Floor: This rounds down a number

  • Mod: This returns the remainder from a division calculation

  • Round: This rounds a number according to the level of rounding

  • Tonumber: This converts a string into a number

  • Truncate: This truncates a number according to the number of digits we require to truncate

  • Rank: This ranks a measure by dimension

How to do it...

Perform the following steps:

  1. We create a rank function that will display each year's ranking based on the Net Sales measure.

    The rank formula will use two parameters: the measure that we require to rank and the dimension that we want to base our ranking on.

    The formula syntax is =Rank([Gross Sales];[Year]).

    The...

Previous Section
End of Section 12
Next Section