what is the issue of below logic in FAW?

User_J7TV2

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")

Bharat Agrawal

Can't see any issue, are you getting any error?

Nathan CCC

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

User_J7TV2

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

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.