|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Thursday, August 06, 2009 11:44 AM
Points: 19,
Visits: 11
|
|
Hi, I have these two tables:
Table: Dim_Source_Database
SourceID
SourceName
Table: Dim_User
UserID
UserName
SourceID
What I need is to create a Hierarchy to show :
Level 1: SourceName
Level 2: UserName
However, when I do that, it shows all users for each SourceName.
I say on SSAS that my primary table is the dim_User and the Key is the UserID.
What am I doing wrong?
Tks
|
|
|
|
|
SSChampion
Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040,
Visits: 1
|
|
| No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
|
|
|
|
