SAP Webi - Drill Options in Reports


Advertisements

The drill option is used to analyze data at different levels. With drilling you can go to the next levels to analyze data in tables, charts, and sections.

You can also specify how drill options will make changes to reports when you perform drilling in Webi. Setting drill options depends on the Web Intelligence interface used.

  • BI Launchpad
  • Webi Rich Client

Setting Drill Option

Note that to use drill option, you should have hierarchy defined at Universe level. Once you have hierarchy at Universe, you can add that object to Result objects in Query panel. Once you run the query, the object will be added to the list of available objects in a Webi document.

Drill allows you to move to level up or level down as per the hierarchy in Universe.

To set drill option in a Webi report, go to Analysis tab → Interact → Drill → Start Drill.

Setting Drill Option

Once you start drill, you can move to the next levels or end drill using the option in the same tab.

Example − Drill on 2015 - the results displayed on the drilled table are Q1, Q2, Q3, and Q4 for the year 2015. This means that the quarterly values you drilled are filtered by 2015.

You can also take a snapshot of Drill result in a separate report. Use the snapshot option to add a new report with drilled data.

Drill Result

Useful Video Courses


Video

SAPUI5 Online Training

25 Lectures 6 hours

Sanjo Thomas

Video

SAP Webi Online Training

26 Lectures 2 hours

Neha Gupta

Video

SAP Basis Online Training

30 Lectures 2.5 hours

Sumit Agarwal

Video

SAP C4C Online Training

30 Lectures 4 hours

Sumit Agarwal

Video

SAP MM Online Training

Most Popular

14 Lectures 1.5 hours

Neha Malik

Video

SAP WM Online Training

13 Lectures 1.5 hours

Neha Malik

Advertisements