Hyperion Employee History Report

posted Apr 13, 2017, 2:22 PM by Barbara Thiss
We now have an Employee History Report available for Hyperion.

The steps to view the report in Excel are as follows: 
  1. Open the Employee History Report Template located on the CRC website under Resources > Guides and Job Aids > Hyperion > Employee History Report--5000 lines--TEMPLATE v1.0.xlsx. Click on Download. The size of the spreadsheet prevents it from opening using View. 
        2. Open the M_Position Employee Allocation form in Hyperion under Forms > LEA > HCP Data View > M_Position Employee Allocation.
    • Export the form to Excel by going to Tools > Export as Spreadsheet.
    • Copy the data and Paste Values into the Position Employee Allocation tab on the Employee History Report Template. 
        3. Open the M_Position Employee Total Compensation form in Hyperion under Forms > LEA > HCP Data View > M_Position Employee Total                                  Compensation. 
    • Export the form to Excel by going to Tools > Export as Spreadsheet.
    • Copy the data and paste values into the Position Employee total Compensation tab on the Employee History Report Template. 
        4. See the calculated totals on the Allocation_Total Compensation tab.

On the Allocation_Total Compensation tab, you can use various tools to view the data:
  • Sort by Fund, Resource, etc. 
  • See only Vacancies 
  • Remove Vacancies 
  • Use conditional Formatting to see duplicate values 
  • Copy the Allocation_Total Compensation information to a new tab to do a pivot table. 
  • Compare the Position Employee Total Compensation to the Total Compensation by using VLookup to see values that differ.