GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Cognos
Go To First  |  Previous Question  |  Next Question 
 Cognos  |  Question 40 of 180    Print  
what is drill down and slicing and dicing whats the difference between them.

  
Total Answers and Comments: 5 Last Update: July 29, 2009     Asked by: ravi 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: sunnyrita1
 

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.

 



Above answer was rated as good by the following members:
hizabr, ravimantur
June 29, 2006 12:49:08   #1  
Ranga Rajender        

RE: what is drill down and slicing and dicing whats t...

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..


 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 2Overall Rating: -2    
July 19, 2006 15:01:53   #2  
sunnyrita1 Member Since: July 2006   Contribution: 6    

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.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
September 08, 2006 14:41:50   #3  
dharanics        

RE: what is drill down and slicing and dicing whats t...

Drill Down: Drill down diging the same dimension

Slice And Dice: Nesting the data between the different dimensions

Dharani CS.


 
Is this answer useful? Yes | No
October 13, 2007 16:04:03   #4  
vipvats Member Since: October 2007   Contribution: 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

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
July 29, 2009 00:10:06   #5  
sarvan_sarvan2007 Member Since: July 2009   Contribution: 1    

What is slicing and dicing?
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.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape