I have two measure groups.. each in its own seperate cubes...
Population_cube 1) population_yearly date_id population_ct
2) medical_cases begin_care_date_id end_care_date_id
I have the following date dimensions 3) dim_date date_id calendar_dt calendar_yr_nr calenar_mont_nr fiscal_year_nr fiscal_month_nr
4) dim_begin_care_date begin_care_date_id begin_care_calendar_dt begin_care_calendar_yr_nr begin_care_calendar_mont_nr begin_care_fiscal_year_nr begin_care_fiscal_month_nr
5) dim_end_care_date end_care_date_id end_care_calendar_dt end_care_calendar_yr_nr end_care_calendar_mont_nr end_care_fiscal_year_nr end_care_fiscal_month_nr
I created two named queries in my cube dsv and then created two cube dimensions off of that named dim_begin_care_date_yr and dim_end_care_date_yr. There is also the generice dim_date dimension defined for the population cube. I created the two named query based dimensions so that I could name the attributes according to their useage. All 3 dimensions are based off of the same original view v_dim_date.
The problem is when I include the population measure group as a linked measure group in my medical_cases cube it thinks it is using seperate dimensions and I cannot then slice and dice the medical_case cube including the population_ct based on dim_begin_care_date.begin_care_calendar_yr_nr as I get the full population_ct as it does not split the population_ct by the year as it thinks it is a different dimension.
How do I use linked measure groups and role playing dimensions with appropriatley named attributes to solve this problem?
Thanks,
