This discussion is archived
5 Replies Latest reply: Oct 14, 2012 6:46 PM by Ahsan Shah RSS

HR Analytics: Headcount calculation query

jhall_uk_redux Newbie
Currently Being Moderated
Hello,

Does anyone know how the headcount metrics are calculated in HR Analytics 7.9.6.3 - say as represented on the Workforce Profile- Overview page? If an employee has two active assignments because they have two job roles, would they be counted twice in these numbers or once?

Is there anywhere were this level of detail is actually described - the metrics guide is pretty high level? I don't have access to an Informatica repository to see where the data is sourced and how.

Cheers,
John
  • 1. Re: HR Analytics: Headcount calculation query
    964810 Newbie
    Currently Being Moderated
    I am unable to answer your main question. But do you have the Data lineage spreadsheet handy ? That would give you the lowdown on the source for a specific metric etc..

    Try the metalink note - Oracle Business Intelligence Applications ETL Data Lineage Guide Release 7.9.6.2 and 7.9.6.3 [ID 1274680.1]

    Good luck
  • 2. Re: HR Analytics: Headcount calculation query
    jhall_uk_redux Newbie
    Currently Being Moderated
    Thank you - I have, yes.

    It looks like w_wrkfc_bal_a holds this in the headcount attribute, but in the data lineage spreadsheet, the detail in the SQL Overrides tab is truncated (this seems to be a common issue with this spreadsheet) - I'm using Excel 2007 and have tried downloading the XLS again. So, I cannot see the code use. As I mentioned, I don't have access to an Informatica environment unfortunately as we don't have any environments in place yet.

    Any thoughts?

    Cheers,
    John
  • 3. Re: HR Analytics: Headcount calculation query
    964810 Newbie
    Currently Being Moderated
    Ok .. I see what you mean.

    I just googled the aggregate table name and found this URL useful http://www.scribd.com/doc/77309289/30/Workforce-Aggregate-Fact-W-WRKFC-BAL-A
    page 13 has an explanation that might give you inputs for further research..

    cheers
  • 4. Re: HR Analytics: Headcount calculation query
    Andy Coates Journeyer
    Currently Being Moderated
    Hi John,

    The only precise way to figure out how the measure is derived is to work with a BI Apps developer to track the measure back through the product stack e.g. OBIEE metadata (RPD) -> DataWarehouse Admin Console (DAC) -> Informatica mappings -> source tables/columns. The ETL, by it's very nature, may manipulate a base measure from the source system (EBS, PeopleSoft etc) in unusual ways. Once you have performed this data lineage, I recommend updating the tool tips (column descriptions) in the RPD to make the product more intuitive for end users.

    So, to answer your question, there is nowhere specifically where this information is described in such detail.

    You may wish to look at the BI Applications metrics reference and the business analytics warehouse data model reference documents in MOS:-

    Oracle Business Intelligence Applications Metrics Reference Guide Release 7.9.6,7.9.6.1 [ID 846917.1] -- I do not believe there will be a later version available until 7.9.6.4 is released
    Oracle Business Analytics Warehouse Data Model Reference Version 7.9.6.3 [ID 1325948.1]

    Please mark as helpful/correct,
    Andy.
  • 5. Re: HR Analytics: Headcount calculation query
    Ahsan Shah Expert
    Currently Being Moderated
    The answer is NO..having 2 job roles will not equal 2 people in your headcount. The ETL process will ensure that each employee is counted once in the target fact table (W_WRKFC_EVT_MONTH_F). Note that you will have Employee and Contingent workers as separate calculations.

    if helpful, pls mark correct/helpful

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points