| October 10, 2007 16:04:03 |
#4 |
| vipvats |
Member Since: October 2007 Total Comments: 2 |
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 |
| |
