27interviews.blogspot

This blog doesn't contain any copied information or copyright content from other sites. Every topic i presented in this blog is authored myself. Every time i tried to help the sapients to understand the concept in an easier way. Thats it. Have a Grt Day!

Translate

WHAT ARE DRILL, DRILL DOWN, DRILL UP, DRILL BY, DRILL ACROSS, DRILL THROUGH, SLICE AND DICE

WHAT ARE DRILL, DRILL DOWN, DRILL UP, DRILL BY, DRILL ACROSS, DRILL THROUGH, SLICE AND DICE


DRILL UP
SECOND->MINUTES->HOUR->->DAY
Month:-Quarter:-Year i.e. One level up in the Hierarchy
Data analysis to a parent attribute.
i.e. vertical movements between components up the hierarchy.
DRILL DOWN
REGION->COUNTRY->STATE->DISTRICT
YEAR:-QUARTER:-MONTH
i.e. One level vertical movements between components down the in the Hierarchy. Data analysis to a child attribute.
DRILL BY
Direct selection of level in the Hierarchy, means you can select one
DRILL TROUGH
Data analysis that goes from an OLAP cube into the relational database. To drill data from one Hierarchy to another Hierarchy, whatever u want that element, means you can drill through to the database directly from drill mode and get the required data.
i.e. you move horizontally between two items via a related link.
SLICE AND DICE
Changing the position of the data like move the data from rows to columns.
 DRILL ACROSS
Data analysis across dimensions.

SOME IMPORTANT POINTS TO REMEMBER:
Drill through is a term used to describe the act of exploring or browsing items like folders, files or related components. Generally associated with drill down and drill up, which indicate vertical movements between components, drill through is an action in which you move horizontally between two items via a related link.

Drill-down is a user navigation step intended to get further detailed information.
For example, you can drill-down to detail report through free Characteristic

An example to drill through is in the case of two reports that are in a master /detail relation with each other, and by clicking a master item on the master report you reach the details of the clicked item on the details report.

To slice and dice is to break a body of information down into smaller parts or to examine it from different viewpoints so that you can understand it better.

In cooking, you can slice a vegetable or other food or you can dice it (which means to break it down into small cubes). One approach to dicing is to first slice and then cut the slices up into dices. In data analysis, the term generally implies a systematic reduction of a body of data into smaller parts or views that will yield more information. The term is also used to mean the presentation of information in a variety of different and useful ways.

This term can be compared to drilldown , which is the process of dividing an information area up into finer and finer layers in a hierarchy, but with the purpose of narrowing in to one small area or item.

Multidimensional analysis tools organize the data in two
primary ways: in multiple dimensions and in hierarchies.

Slicing and dicing refers to the ability to combine and re-combine the dimensions to see different slices of the information. Picture slicing a three-dimensional cube of information, in order to see what values are contained in the middle layer. Slicing and dicing a cube allows an end-user to do the same thing with multiple dimensions.

slice and dice is to arrange the data in different ways. it can change as rows to columns  and columns to rows.
Post a Comment
There was an error in this gadget