Slice & Dice?

Not related to a specific OLAP tool. (Includes forum policies and rules).
Post Reply
Posts: 1
Joined: Fri Jul 24, 2009 12:14 pm
OLAP Product: none
Version: none
Excel Version: none

Slice & Dice?

Post by Lisalein » Fri Jul 24, 2009 12:15 pm


i have a little problem to understand slice & dice correctly. Maybe someone can tell me if I am right...

Lets say we got a cube with the Dimensions:

Time: (Jan.;Feb.;March....)
Region: (Town A, Town B, Town C, Town D)
Product: (Prod A, Prod B, Prod C, Prod D)

and I want to calculate the volume of sales.

Examples for Slice:
- Volume of sales for product a. (Shows a table with all regions and dates of product a)
- Volume of sales in town b. (Shows a table with all products and dates in town b)

Examples for Dice:
- Volume of sales for products a and b in town c and d (all times).
- Volume of sales for products a,b,c in town a and c in january and february.

Are these examples correct?

Thank you very much,

User avatar
Steve Rowe
Site Admin
Posts: 1871
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Slice & Dice?

Post by Steve Rowe » Fri Jul 24, 2009 2:13 pm

Hi Lisa,

I'm not aware that a Slice and a Dice have explicit meanings and definitions as such. "Silce & Dice" really means "manipulate the cube (rearange the dimensions and elements) until you get to the view you want and then report on it".

Not much of an answer I know...


Post Reply