<div>
<div class="content wysiwyg-content">
I have two fact tables that share the same dimension (consumer) but have different grains ..<br />
<br />
Fact A:<br />
<br />
Consumer_key, Episode_key, Episode_Begin_date_key,ass<wbr />essment_ke<wbr />y<br />
<br />
Fact B:<br />
Consumer_key, Episode_key, Service_begin_date_key, Sum_of_Cost<br />
<br />
<br />
<br />
There is 1:M relationshiop between Fact A and Fact B...<br />
<br />
IS it a bad idea to join two fact tables to get a result ?<br />
DO I have to always use a common dimension table , in this case, DimConsumer to join to fact tables?<br />
<br />

</div>
</div>


I have two fact tables that share the same dimension (consumer) but have different grains ..

Fact A:

Consumer_key, Episode_key, Episode_Begin_date_key,assessment_key

Fact B:
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?



Join Two fact tables that has different grain

A virtual private network (VPN) is a network that uses a public telecommunication infrastructure, such as the Internet, to provide remote offices or travelling users access to a central organizational network securely. VPNs encapsulate data transfers using secure cryptographic methods and other security mechanisms to ensure that only authorized users can access the network and that the data cannot be intercepted.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.