Thursday, February 28, 2013

[SAP BO] Drill In Business


Drill in Business Objects(BO)

With Business Objects(BO) the data is analyzed in different perspectives. BO data can be organized using different mechanisms like DRILLING or SLICING and DICING.

On report analysis:

Allows to work directly on the data in the report using drag and drop or with simple mouse clicks.

The data can be added from the Report Manager to create tables and sections.

Option to replace, swap and re‐organize data on the report is possible.

Sort, filter, and rank is possible using a simple mouse click to focus the analysis on a slice of data.

Drill mode:

Allows to analyze data from different angles and on different levels of detail. Typically, start off by looking at the high level data and when you spot an unusually low or high value, or an unexpected value, you can analyze it by displaying related data on a more detailed level.

Slice and Dice mode:

Allows to organize data for analysis in the slice and dice panel. Slice and dice panel allows to add, delete, and swap data round, to analyze the data from a different viewpoint.


 Drill mode is an analysis mode that allows breaking down of data and view on different angles and different levels of detail to discover what the driving factor is behind a good or bad result.

Objects in a universe are organized in hierarchies, with the most general object in the class at the top and the most detailed at the bottom. Objects are organized in this way for drilling.

When the data is analyzed in drill mode, the hierarchies are used. The universe classes are the default hierarchies used for drilling but the universe designer can also set up custom hierarchies.

Creating hierarchies is possible at report level too.

Drill hierarchies contain dimension objects only. Drill is possible on dimension objects, not on measures or details.

Scope of Analysis

Before analyzing data in drill mode, set up the scope of analysis. “Scope of analysis” means a subset of data, returned by a query, that will be used for analysis in the report.

Drilling Options

The table, crosstab, or chart that needs to be analyzed in drill mode is selected first. The different options available in drill mode are:

Drill-Down : The next level of detail in a hierarchy is viewed. During drill down, you view data at more detailed levels.

Drill-Up : During drill up, you go back up through the hierarchy to display data on less detailed levels.

Drill-By : When you drill down and up you move through the levels of the same hierarchy. However, if you cannot find the answer to a question by analyzing data in its current hierarchy, you can move to another hierarchy to analyze other data.

Drill-Through : If the lowest level of detail required is not currently available in the report, you can drill through to the database directly from drill mode and get the required data. You do not have to edit the query in the Query Panel.

Drilling on Multiple Hierarchies

If a block contains more than one hierarchy, you can simultaneously drill down from one dimension to the next in all the hierarchies in the block.

For example, Double‐click on the Revenue column in the cell that displays revenue for Hawaiian Club in FY1998.

Desktop Intelligence moves Resort and Year to the Drill toolbar. The values in the Drill toolbar are Hawaiian Club and FY1998. Service Line and Quarter appear in the table and Desktop Intelligence updates the Revenue column.

Drilling Using Custom Hierarchies

You may find that the default order in which dimension objects are arranged in hierarchies is not optimal for your analysis needs, or that you need to drill on a hierarchy that has objects from different classes.

You can edit a hierarchy by changing the order of the dimensions it contains, by adding dimensions to it, and removing dimensions from it. You can also rename a hierarchy, and even delete it.

You can also create your own hierarchies using dimensions available in the report or by using user objects. There are two types of custom hierarchies:

Pre‐defined custom hierarchies that are set up by the universe designer and which can be re‐used in other documents.

Hierarchies you create yourself and which are saved only in the document you created them in

No comments:

Post a Comment