Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmak
Starting Member
41 Posts |
 Posted - 2006-07-21 : 19:30:42
|
| I am new to SQL Analysis Services. I have a cube with several dimensions with it. I want to assign some transformation to the content to one of the dimension. The transformation I normally assign to the store procedure as follow: protocol_code = Case When Upper( protocol_code) > 'A'And DataLength( protocol_code) > 1And SubString( protocol_code, 1, 1) <= 'Z'Then Upper( protocol_code)Else ' UNSPECIFIED' EndHow to assign this tranformation to a column in the dimension?Paul Mak |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2006-08-01 : 10:48:35
|
| Hi,Why not define a column in your dimension table containing the result of the expression you gave? This is what a dimension table is for. You can use the dimension column as an attribute in your Cube dimension.Jeroen |
 |
|
|
|
|
|
how to assign transformation to a dimension?