RE: what is drill down and slicing and dicing whats t...
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.
RE: what is drill down and slicing and dicing whats t...
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
