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