creating a range dimension

#1

I want to be able to create a dimension according to an amount field that is
available in my fact table i.e. divide the data according to:
0 to 10 k
10 to 20 k
20 to 500 k
and so on
is there a way for doing it....

#2

You can define as the source field for your dimension a SQL statement like
this
CASE WHEN Amount between 0 and 10000 then 'a' when unitprice
between 10000 and 20000 then 'b' else 'c' end

Francesco Anti

"naraby" <naraby (AT) discussions (DOT) microsoft.com> wrote

Quote:

I want to be able to create a dimension according to an amount field that
is
available in my fact table i.e. divide the data according to:
0 to 10 k
10 to 20 k
20 to 500 k
and so on
is there a way for doing it....

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

creating a range dimension

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

creating a range dimension - 06-22-2005 , 09:03 AM

Re: creating a range dimension - 06-22-2005 , 10:07 AM