cancel
Showing results for 
Search instead for 
Did you mean: 

Drill Concept

Former Member
0 Kudos

Hi All,

I want to know what is the exact difference between Drill down, drill up & drill by

Can any one help on this

Regards,

Mahendra

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member182541
Active Contributor
0 Kudos

Drilling up

Drilling up means to replace the data you are drilling up on with the data for the parent element of that data. You drill up to compare data.

Drilling down

Drilling down means to replace the data you are drilling down on with the data for the child element of that data. You drill down to see more detail about data.

Example : Year contains Months, Months contains Weeks, Weeks contains Days, Days contains Hours, Hours contains Minutes.

Drill through or Drill by

Drill through takes him to a report that is relevant to the data being analyzed, also at the click of a mouse. For example, a tabular report that shows sales revenue by state can allow the user to click on it and reveal an analysis grid of the same data, or a heat map representing the data in visual form. It is called “drill through” because it is a feature that allows the user to pass from one report to another while still analyzing the same set of data.

Example: By Passing ID through a report block and getting a completely new report through open-document link.

Former Member
0 Kudos

Information is helpfull,Thankyou Boss.

Former Member
0 Kudos

Hi Mahendra,


Check the below link. Everything is explained very neatly.

http://blog.davidg.com.au/2011/03/drill-down-in-xcelsius-using-bi.html

Former Member
0 Kudos

Hi Mahendra,

There are lots of pdfs and tutorials available on internet. For example, go through below pdf for basics:

http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_webi_java_en.pdf

Regards,

Yuvraj