I am new to OLAP and I was wondering if it is possible to create a dimension
in Analysis Services 2005 based on a range of values for a given field in a
Fact table.
Example:
Field Name: Quantity
Dimension Name: Quantity Range
Dimension Values: 0-100
101-200
201-1000
QuantityRange that is computed based on the value of the quantity
1: 0-100
2: 101-200
3: 201-1000
4: > 1000
The values 1 to 4 would be my dimension.

Thanks al lot

If you are defining the thresholds, then Yes, you must create such a
structure. It could be a simple view with some UNION statements. Here is an
example:

CREATE DimVendorType AS
SELECT 'S' AS Vendor_Type_ID, 'Source Vendor' AS Vendor_Type
UNION
SELECT 'O' AS Expr1, 'Original Purchase Vendor' AS Expr2
UNION
SELECT 'P' AS Expr1, 'Purchase Vendor' AS Expr2
UNION
SELECT 'R' AS Expr1, 'Return Vendor' AS Expr2
UNION
SELECT 'D' AS Expr1, 'Distribution Center Vendor' AS Expr2

If you want AS to use the DM algorithms to create the thresholds for you,
then just set the DiscretizationMethod property to automatic.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


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