I have 2 fact tables (Goals and Sales) with values.

 Goals includes a 4-digit year value.  Sales has an actual date in the format of mm/dd/yyyy.  I want to be able to filter the cube in the cube browser by year, with both goal and sales values.

However, how can I use the year value in both measure groups?

In  Dimenssn Usage tab, I have Sales using the Date dimension based on the date key, whereas the Goals using the Date based on the Year.  Something is not right, as the Goals measure isnt changing when browsing in the cube.

[update]
What im trying now, is building a regular dimension explicitly for all the available years in both fact tables.  this list is determined at run time within the ETL that populates the DW database.  Then I can populate a new year-only field in the current fact table (Goals) that only has a year value.  Then I can tie both fact tables to this new dimension.  What Im not sure of is how to filter Goals based on the year of the Date dimension?

• Edited by shiftbit Friday, July 31, 2015 8:55 PM dfdf

Do  you mean Goals measure doesn't change for quarters/months within a given year? See e.g. http://parasdoshi.com/2014/08/06/ssas-joining-facts-at-different-granularity-to-a-single-dimension/ for a simple workaround. If Goals displays the same for all years, you probably have a key format issue, e.g. trying to join a String to an Integer, or to a Date.

It is possible to split goals to lower date grain in the cube with scoped assignments.

The last question is a puzzle. Your measure value should filter naturally when you have set up a correct relationship between the measure group and the dimension. You don't really need another dimension, different grain relationships to the regular Date should work.