Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Slice and Dice

Answered Slice and Dice

  • Thursday, January 17, 2013 5:12 AM
     
     
    Sign In to Vote
    0

    Hi,

    I am new to SSAS. I tried to understand Slice and Dice. What's the difference between Slice and Dice.

    Thanks

    Sea Cloud

     

All Replies

  • Thursday, January 17, 2013 5:52 AM
     
     Answered
    Sign In to Vote
    0

    Single dimension member if you bring in where clause for filtering it becomes Slice. If you bring multiple dimension member on where clause it become dice.

    Select {[measure].[abc]} on 0,

    from cube

    where [Customer].[Customer].&[250] --- this is slice

    Select {[measure].[abc]} on 0,

    from cube

    where {[Customer].[Customer].&[250],[Product].[Product].&[100]} --- this is dice

    • Marked As Answer by SeaCloud Friday, January 18, 2013 12:13 AM
    •  
     
  • Thursday, January 17, 2013 5:56 AM
     
     Answered
    Sign In to Vote
    0

    Slice and Dice = drill down and drill up 

    Slice is the act of picking a rectangular subset of a cube by choosing a single value for one of its dimensions, creating a new cube with one fewer dimension.

    Dice: The dice operation produces a subcube by allowing the analyst to pick specific values of multiple dimensions.

    http://en.wikipedia.org/wiki/OLAP_cube

    • Proposed As Answer by mcprakash Thursday, January 17, 2013 2:12 PM
    • Marked As Answer by SeaCloud Friday, January 18, 2013 12:13 AM
    •