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.
Drilling down the data means to change the resolution of the dimension we are looking for Once the resolution or level of the dimension 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
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!