MS SQL Server OLAP - SSAS: Creating a Multi-table Dimension

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SSAS: Creating a Multi-table Dimension

carlos.rodrigues@recall.com

2005-12-20, 7:23 am

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

Sponsored Links