I have two fact tables that share the same dimension (consumer) but have different grains ..
Consumer_key, Episode_key, Episode_Begin_date_key,assessment_key
Consumer_key, Episode_key, Service_begin_date_key, Sum_of_Cost
There is 1:M relationshiop between Fact A and Fact B...
IS it a bad idea to join two fact tables to get a result ?
DO I have to always use a common dimension table , in this case, DimConsumer to join to fact tables?