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 |
|
Ali Chadorbaf
Starting Member
44 Posts |
 Posted - 2007-05-14 : 16:12:24
|
| I am very new in cubes. I would like to concatenate two columns at dimension level but no change at the base table. For example the drop down dimension at the Cube browser shows (customerName + customerID) like ( AAA 1000 ).Any help would be appreciated. |
|
|
joshua.lyon
Starting Member
1 Post |
Posted - 2007-05-24 : 16:49:53
|
I can't think of a good way to do this in MSAS. The simple way of doing this is just creating a view that concatenates the two columns into one, then use that column in the dimension.I don't know why I was having a total brain-fart on this one. Expand the dimension that you've created and select the level you want to modify. In your example, this might be Customer Name or Customer ID. In the properties box on the basic tab there is a field called Member Name Column. Simply do your concatenation here. eg: "BOOKINGS"."CUSTOMER"."CUST_NAME" || ' ' || "BOOKINGS"."CUSTOMER"."CUST_ID"View > Properties - if the properties window isn't open |
 |
|
|
|
|
|
Concatenate columns