Analysis manager 8.0 will not let you use user-defined SQL functions in
dimension column definitions of the member key column or the member name
column or member properties. Apparently the "." in the UDF call confuses
analysis manager which tries to match the function call to an actual field
name. To reproduce this just try to define a member property based on a UDF.

dbo.UDF_Function( "table"."column" )

Does anyone know of a workaround to use UDFs in the dimension definition?

How about creating a view on top of the dimension table you are processing
against in which the view contains the UDF - and then creating your Olap
dimension against that?

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



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