We have a fact table (Orders) with 6 columns
Date, Month, Year, Customer Type, Customer Number, Order Number

We have a goal table (Goals) with 4 columns
Goal Year, Goal Month, Customer Type, Goal Value

There is a relationship between the two tables on Month, Year and Customer
Type

We have a cube built on the Orders Table and have a measuer (Order Count)
that is a count of rows.

We want to build a KPI based on the Order Count measure and want to
establish the goal for the KPI from the Goals table. Since there is a
1-many relationship between the Goals table and the Orders table, how do we
associate the goal values in the goal table with the Order Count KPI at the
Year+Month+Customer Type level?

Thanks
~Steven