what is the issue of below logic in FAW?

Question

cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> 'null') and ("HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1' or "HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~NOVALUE~') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~null~') and ("HCM - Workforce Gains and Losses"."Business Unit"."Business Unit Name" in ('PTL US Corp','PTL US Field','PL US Corp','PL US Field')) and ("HCM - Workforce Gains and Losses"."Country"."Country Code"='US' ) ) as double)/COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")

Nathan CCC · Answer

Hi, This is I assume the correct forum for you to use for this question Fusion HCM Analytics.

Please ask the admin to move it across out of OTBI.

User_J7TV2 · Answer

Issue of logic in FAW.png and I'm using a simple logic in calculation, Please see the below.. C - NUMERATOR DIVERSE PROMOTIONS: cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> 'null') and ("HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1' or "HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~NOVALUE~') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~null~') and ("HCM - Workforce Gains and Losses"."Business Unit"."Business Unit Name" in ('PTL US Corp','PTL US Field','PL US Corp','PL US Field')) and ("HCM - Workforce Gains and Losses"."Country"."Country Code"='US' ) ) as double) C - DENOMINATOR DIVERSE PROMOTIONS: COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number") C - DIVERSE PROMOTIONS: cast (FILTER ((COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number")) using ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> 'M' or "HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> 'null') and ("HCM - Workforce Gains and Losses"."Ethnicity"."Ethnicity Code" <> '1' or "HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~NOVALUE~') and ("HCM - Workforce Gains and Losses"."Diversity"."Gender Code" <> '~null~') and ("HCM - Workforce Gains and Losses"."Business Unit"."Business Unit Name" in ('PTL US Corp','PTL US Field','PL US Corp','PL US Field')) and ("HCM - Workforce Gains and Losses"."Country"."Country Code"='US' ) ) as double)/ COUNT(DISTINCT "HCM - Workforce Gains and Losses"."Basic Information"."Person Number") Please help me for this issue. Thanks.

Nathan CCC · Answer

Hi,

This forum is NOT for Fusion Analytics Warehouse (FAW) recently rebranded Fusion Data Intelligence. This forum is for Oracle Transactional Business Intelligence (OTBI) inside Software as a Service (SaaS) suite Oracle Fusion Cloud Applications.

Looks like your question is NOT a query from a subject area in OTBI.

Subject area "HCM - Workforce Gains and Losses" is not in the list of subject area in OTBI

Oracle Fusion Cloud HCM

Subject Areas for Transactional Business Intelligence in HCM

F92793-01

24B

https://docs.oracle.com/en/cloud/saas/human-resources/24b/faohb/index.html