hi

trying to create a dimension from a fact column that has some information
that I'd like to truncate.
example, 0-Developer, 1-Tester, I'd like to remove the number and hyphen
before it's becomes an dimension member, can this be done ?

thanks,

Sure. Two options: 1) use a view (Analysis Services loads from a view as
well as a base table) or 2) use TSQL substring on the member name field.
Just run the dimension wizard and create the dimension. For the member key
and name property setup the field that contains "1 - Tester". Then in the
dimension editor, change the field to be some TSQL string manipulation (with
Locate and Substring functions) to parse our the key and member name.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Maersa" <ma_ersa (AT) hotmail (DOT) com> wrote

Hi Dave,

I'm new to AS, but is it in the property window where I change the field ?
There's a "Basic" tab with the Member Key Column property and Member Name
Column, is this where I change it ?

tried doing ... LCase("defect"."bug_type") and an error was thrown.

thanks,

"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote