Ranga Rajender

• Jun 29th, 2006

 

am not sure how to define a drill down but slicing can be defined as cutting horizontally along the dimension is slicing

and cutting vertically along the measure is dicing..

sunnyrita1

 Profile 

• Jul 19th, 2006

 

Drilling lets you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy; drilling up moves you up in the hierarchy.

Slicing and Dicing

While you can drill to look at information at any level, you can slice and dice to select the exact information you want in your report.

 

dharanics

• Sep 8th, 2006

 

Drill Down: Drill down diging the same dimension

Slice And Dice: Nesting the data between the different dimensions

Dharani CS.

vipvats

 Profile Answers by vipvats 

• Oct 13th, 2007

 

Drilling down the data means to change the resolution of the dimesion we are looking for. Once the resolution or level of the dimesion drops down we have more information from a part of a dimension. for example let us consider time as one of the dimension when we are looking for the sales of a enterprise. If the analysis is done by considering the years for the sale of a product then it would be level 1. If we drill trough time dimension then we can have a look at the sales of the product for the quater period of year and analyze the sales in 4 quaters of a particular year. this is having better resolution of the sales of that product

Slicing is a process which could be used to eliminate the data which is not necessary for current analysis. for example if we are interested in analysis of the sales of a product during the first quater of the year then we can drill down the time dimension to resolution 2 level and then slice the cube for the first three months leading to the slicing process

If the above process is carried out in certical direction we call it dicing

sarvan_sarvan2007

 Profile Answers by sarvan_sarvan2007 

• Jul 29th, 2009

 

Slicing is a process in which you do an equality selection of data from one or more dimension(perspective of facts how it can be interpreted).

In dicing, you obtain a dataset in a range of selection.