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 ?

[293 byte] By [daniel] at [2008-1-2]
# 1

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

Christina at 2007-9-13 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...

SQL Server

Site Classified