We now have an Employee History Report available for Hyperion. The steps to view the report in Excel are as follows: - 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.
|