Saturday, February 25, 2012

cube design question (beginner)

Hi,

Let's say that i have a fact table with sales and one time dimension and i want to display the count of sales over the bands of sales; something like this:

0-750 750-1000 1000-1250

2004 1 12 5

2005 0 9 11

2006 2 13 40

Any sugestion ?

i suggest you create a dimension of this fact table, and create an attribute with the sales measure and use the DiscretizationBucketCount and DiscretizationMethod to configure the bands.

hope this helps

No comments:

Post a Comment