I'm having a bear of a time concating the last name and first name of my
customers.
I've created a new dimension and selected one column as the Member Key
Column "dbo"."EN_CUST_PROFILE"."PROFILE_LASTNAME"
I need to respresent the users name as a lastname, comma, firstname string.
So I input the lastname and firstname as the member key column like so:
"dbo"."EN_CUST_PROFILE"."PROFILE_LASTNAME" +
"dbo"."EN_CUST_PROFILE"."PROFILE_FIRSTNAME"
this works fine.

My problem is when i try to add a comma. The following throws an error:
"dbo"."EN_CUST_PROFILE"."PROFILE_LASTNAME" + ", "+
"dbo"."EN_CUST_PROFILE"."PROFILE_FIRSTNAME"

Can someone show me how this is done? it seems as if it should be easy.

Thanks,
Lyndon

"dbo"."EN_CUST_PROFILE"."PROFILE_LASTNAME" + ', '+
"dbo"."EN_CUST_PROFILE"."PROFILE_FIRSTNAME"

Ohjoo Kwon

"lh" <lhughey (AT) gmail (DOT) com> wrote

DOH!!!!
Thanks for the obvious fix. I cant believe i didn't think of that.


"Ohjoo Kwon" <ojkwon (AT) olap (DOT) co.kr> wrote