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 |
|
bridge
Yak Posting Veteran
93 Posts |
 Posted - 2005-05-02 : 08:04:16
|
| How can we add two columns in a dimension. Like User Name column made up of First Name and Last Name |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-05-02 : 14:25:36
|
| As MemberName of the dimension level specify:"dTable"."FirstName" + ' ' + "dTable"."LastName"rockmoose |
 |
|
|
bridge
Yak Posting Veteran
93 Posts |
Posted - 2005-05-03 : 00:57:03
|
| Thanks, Actually I was trying as"dbo"."Users"."FIRST_NAME" + " " + "dbo"."Users"."LAST_NAME"and it did not allow me |
|
|
|
mateamargo
Starting Member
10 Posts |
Posted - 2005-06-10 : 11:32:38
|
| Does this kind of dimension let you make a Drill Thorugh? because I had problems using Member Keys with Case. |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-06-10 : 11:57:08
|
I don't know, try it or wait for someone who knows  rockmoose |
|
|
|
|
|
|
2 columns in a Dimension