Slice & Dice?

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

Slice & Dice?

Post by Lisalein »

Hi,

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,
Lisa
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Slice & Dice?

Post by Steve Rowe »

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

Cheers,
Technical Director
www.infocat.co.uk
Post Reply