Forum Discussion
filtering multiple dimension tables
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?
3 Replies
froelichgr , Ideally you should merge employee and division and use that as dimension
My problem with that is the Mfg Orders don't have a relationship with employee
Did you manage to solve this? I have the same issue
