Joining fact tables with non confirmed dim

Reeni

Hi,

Please tell me how to design RPD for the following report requirement

HTOPS fact table and HFPAY fact table have one dimension in common that is Program_Loc_Dim

HFPAY is have one more dimension called F_TYPE_Dim

Report columns

1. Program office code => Program_Loc_dim.program_code

2. Col2 => count( HTOPS.pos)

3. Col3 => count( HTOPS.vac)

4. Col4 => SUM( case when F_TYPE_Dim.fcode = 'ED' then HFPY.Fval else 0 end)

Please tell me how should I join two facts and two dimension tables in RPD.

Thanks

[Deleted User]

a) "conformed" dimension. Ther term has nothing to do with "confirming something" but "

b) duplicate thread: Joining fact tables with non-confimed dimension

c) Close this thread!