Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Joining fact tables with non confirmed dim

Received Response
1
Views
1
Comments
Reeni
Reeni Rank 1 - Community Starter
in Oracle Business Intelligence Applications Forum

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

Answers