Oracle Fusion HCM Analytics

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

What is the issue of below logic in FAW?

Received Response
21
Views
4
Comments
Rank 3 - Community Apprentice

 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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    Hello,

    It does not look like there is any problem with your logic but little tweeks may be required depending on the results. To troubleshoot this, include the calculated column with at least 1 fact and 1 measure from each Subject Area you use in the calculation in a Tabular (Table) Workbook. Change the aggregation method from Auto to SUM or whichever option you want to test with. Then provide the results to Support via an SR with an exported .dva file.

    Regards,

    John

  • Rank 3 - Community Apprentice

    Hello,

    I'm unable to Change the aggregation method from Auto to SUM since not visible.

    Please help me this.

    Thanks,

     

  • Rank 8 - Analytics Strategist

    Please Use the tabs in the Properties pane, select the measure and aggregation type.

  • Rank 3 - Community Apprentice

    I try the same way but unable to do it.

Welcome!

It looks like you're new here. Sign in or register to get started.