Dimension Usage - How to JOIN multiple attributes?

Question

Quick question - I have a Budget FACT that join both Region & Country attributes in an existing GEO DIM.  I forgot how to join multiple columns.  In the relationship, how can I select both dimension columns?  

The goal is to use either GEO DIM's Region or Country to slice Budget numbers.  The lowest granularity of GEO DIM is at CITY ID Level.

Your help is appreciated!

Answer 1

I figured out how to join multiple columns in DIMENSION USAGE. 

However, I am having problem with attribute relationship when I need both FACTS to show proper relationship.  I can get one FACT to work, but when both FACT are deployed, dimensions attributes overlap, therefore I am not sure how to set proper attribute relationships.

Error - Attribute key is a duplicate.  Attribute: Region of Dimension GEO.  Attribute key value: "Unknown".

Goal - I have two FACT Budget & Estimate that need to join with DIM GEO.
FACT Budget   - JOIN DIM GEO on Region & MediaType attributes
FACT Estimate - JOIN DIM GEO on Region & Country attributes

As you can see, Region attributes overlap between the two FACT. 

Attribute Relationship that's NOT working
CITYID --> Region
Region --> RegionMediaType
Region --> RegionCountry
RegionMediaType --> Media Type
RegionCountry --> Country

Attribute Relationship that IS working when I only use 1 FACT Budget

CITYID --> RegionMediaType
RegionMediaType --> Region
RegionMediaType --> Media Type