Section breaks up the data into multiple cells that are called section headers and each section header contains a value for dimension and data corresponding to dimension value.

Break is used to divide the data into one block and each column carries dimension, attributes and measures. These values are repeated for each row value in the block.

How to Insert a Break?

Select the column in which you want to insert a Break. Go to Analysis → Display → Break → Add Break.

1 53

This will divide the table into many mini tables as there are unique values in the column.

2 52

Manage Breaks

To manage a break, you should use Design mode.

Go to Analysis → Display → Break → Manage Break. It will open a new window and show all the breaks in the table.

3 52

You can define the following properties about Break in this dialog box. You can prioritize Break using up-down arrows.

Display Properties
Page Layout
Duplicate Values

4 48

You can also Add or Remove a Break using Break Properties.

SAP Webi – Ranking Data

You can rank the unranked data from the database in your report. Database ranking allows you to rank the data at database level so when you run a query, data returned by query is already ranked.

Database ranking is done by editing the script generated by query. If your database doesn’t support ranking, then the option to create ranking will not highlight in query panel.

Also note that Ranking can’t be created on hierarchical data.

Creating Database Ranking

First add the objects to Result Objects in Query panel. Select Add Ranking at the top of Query filter pane.

5 43

Select the ranking dimension and type – top, bottom, top %, and bottom %.

You can select the number of records or % of records you want the rank to return in the next box. Drag the ranking dimensions, measures, to based-on box. You can also drag dimensions to provide a calculation context to Ranked by box. You can also add WHERE condition by dragging a dimension to the bottom of ranking.

Click Run Query.

6 36

SAP Webi – Sorts

Sorting can be applied in table on sections, charts to organize the data in a specific order in a Webi report. Default sorting that is applied in a report is from left to right order of objects in Result object of Query Panel.

You have the following Sorting Orders −

Default − This is default order where data is sorted as −

Ascending numeric order for numeric data
Ascending chronological order on date
Chronological order for months
Alphabetical order for alphanumeric data
Ascending − In this, smallest value at the top to highest value at the bottom. Example − 1000, 2000, 3000, or Delhi, Kolkata, Mumbai
Descending − In this, highest value at the top to smallest value at the bottom

Custom − Using this, you can define your own sort order. Custom orders are available on dimensions and attributes and not on hierarchies, measures and level.

How to Insert a Sort?

To insert a sort, open report in Design mode. Select the Column you want to sort.

Go to Analysis → Display → Sort → Ascending/Descending

7 29

8 26

You can apply multiple sorts in a single table on different columns. You can use ‘Remove All Sorts’ option to delete all the sorts.

To manage the Order of Sorts, go to Advance tab. You can define order for all sorts using up and down arrows. You can define Custom Sorts here if no other sort is applied.

9 18

This can also be used to Add/Remove Sorts.

So, this brings us to the end of blog.
This Tecklearn ‘How to use Breaks, Sorts and Ranking Data in SAP Webi’ blog helps you with commonly asked questions if you are looking out for a job in SAP Business Object and SAP Domain. If you wish to learn SAP Web Intelligence and build a career in SAP domain, then check out our interactive, SAP Business Objects Certification Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/sap-business-objects-certification-training/

SAP Business Objects Certification Training

About the Course

Business intelligence tools and features are used by multiple companies and firm for the effective results their large flow of data. The completion of this SAP Business Objects training will be helpful in landing yourself a good paying job. With this Business Objects online training, you will gain considerable proficiency in SAP BO architecture, data warehousing, use of Information design tool, create multiple reports and the implementation of Web intelligence and Efficiency in solving the issues of data sources and Crystal dashboard design.

Why Should you take SAP Business Objects Training?

The Average salary of SAP Business Objects Business Intelligence Analyst is $94,000 per annum – PayScale.com
Business Objects is an enterprise reporting tool and Scalability is one of the primary reasons large corporations choose Business Objects for their BI needs.
Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in next 2 years – Gartner.

What you will Learn in this Course?

Introduction to Business Objects

History and Version of Business Object
How Business Objects works in SAP family
SAP BO-Business Intelligence package and tool list
Data warehousing concept from SAP perspective

SAP Business Object Architecture

SAP BO Architecture
Various tiers in architecture: Client, Processing, Intelligence

SAP Web Intelligence

Web Intelligence Overview
Variable in Web Intelligence environment

Using Universe Designer Tools (UDT)

Overview of the Universe Designer Tool
Working with shared, secured and personal connections
Understanding of the Semantic layer

SAP BO Reports

SAP BO Reports
Chart Reports, Table Reports, Sorting and aggregating of Reports
Various elements of Reports, graphs, text elements
Reports and Filters
Section Report
Break Report
Alerts Report
Scope of Analysis Panel
Conditional Reporting
Ranked Report
Drill Report

Advanced Formatting

Advanced methods of formatting in SAP BO
Identifying Chasm trap and resolving Chasm traps with various methodologies
Detection and resolving of loop

Information Design Tool (IDT) Integration

Introduction to SAP BO information design tool
Extracting data from various sources using OLAP methodologies
Creating of Universe with IDT
IDT Vs UDT
Working with IDT as an Integration tool

Getting started with Crystal Dashboard

Data visualization tool for creating interactive dashboards
Point-and-click Features
Various dashboard features and interface

Live Office

Live office
Detailed design of Crystal Dashboard

SAP BO 4.2 Features

Got a question for us? Please mention it in the comments section and we will get back to you.

567