Headcount FTE Analysis (HFA)

Headcount FTE Analysis (HFA)

Headcount Full-Time Employee (FTE) Analysis (HFA) is intended to answer the primary question: How many and what type of employees did I employ over time? This question implies that the user is interested in a summarized picture of headcounts in their organization. The product suite includes a data cube and data mart.

About Headcount FTE Analysis

Headcount FTE Analysis is designed specifically for individuals who want to look at Headcount or FTE changes over time. Its goal is to be easy - or at least easier than writing your own reports. However, to be fair, this is not report writing; this is analysis. That means you do not need to have a specific question. You may have a question to begin with, but what you really want is to learn about how your Headcount or FTE has changed over time; to slice and dice the data.

For more information or to get started, consult the following resources. All files are Adobe PDF format.

Headcount FTE Analysis Guides and Support

Connecting to Headcount FTE Analysis

Headcount FTE Cube and Tables have Incorrect Records November 7
AITS has identified a problem with the Headcount FTE Analysis cube and associated tables. Approximately 5% of the historical records (prior to September 2011) are incorrect. AITS is currently updating and testing the load process to resolve this issue and will reload the associated tables (T_HC_EMPEE_DEMO_DIMENSION, T_HC_EMPEE_DIMENSION, T_HC_EMPEE_POSN_JOB_FACT, and T_HC_POSN_JOB_DIMENSION). We anticipate the Cube will be corrected with the December load (12/11). We appreciate your patience and apologize for any inconvenience.