filtering multiple dimension tables

[froelichgr]

I feel like this should be a basic question, but I can't get my head around it.  I'm trying to filter multiple dimension tables that have a common field.    Example I have 2 dimension tables (Employee and Orders).  Both Employees and Orders have a column of Division.   

Employee and Order are not related, but there are employee transactions for each order.  So if I use the Division table as a bridge, it creates ambiguity for the transactions.  How would I go about filtering out Employees and Orders by Division?

[amitchandak]

@froelichgr , Ideally you should merge employee and division and use that as dimension

[froelichgr]

My problem with that is the Mfg Orders don't have a relationship with employee

[powerbicycle]

Did you manage to solve this? I have the same issue