Workforce Actuals - Data Load Rules

Employee Actuals

You can load employee actuals to Workforce Planning at the Employee and Account level for reporting Variance Analysis. This will help to significantly reduce the manual work at the start of every month to update forecasts for Employee Actuals vs. Planned Variance.

This feature will allow you to perform the following:

• Use the Actual Scenario to store Workforce Actuals data by month/period depending on your tenant configuration
• Use Data Load Rule imports to load Actuals into Workforce Planning
• Delete loaded actuals by month to re-import in case of any mistakes

The File load and Copy-Paste options are available for loading.

In Practice:

Define New Data Load Rule

1. Navigate to Maintenance > Data Integration > Data Load Rules.
2. Click the New Data Load Rule tab available in the side navigation.
3. Enter a Name for the Data Load Rule.
4. Select Load Type from the drop-down list. File Load and Copy-Paste are the load types supported by the system.
5. Select Workforce Planning as a Load Item from the drop-down list.
6. Select Workforce- Employee Actuals as a Load Sub Item from the drop-down list.
   

7. Now click Next. The Select Sample Input File screen is displayed.

Select Sample Input File 

Fill all the fields with specific data and click Next. The Define Overall Rule Settings screen is displayed.

Define Overall Rule Settings

1. Select a Load Currency Type. Local Currency (Allocated Currency) and Common Currency are the two types supported.
   
2. Select an Aggregation at Time Roll up condition from the drop-down list. Default, None, Sum, First, Last, and Avg are the types supported.
3. Select a Time Mapping from the list; by default, the value is Across Columns.
4. Select Yes as the Automatic Cube Refreshvalue to avoid manual cube processing.
   Note:

   In the Defaults section, all the fields are mandatory, so you must select a value for each of them.
5. Select Include In Data File from the Employee Name drop-down. 
6. Select Include in Data File Data File from the Employee Position Description drop-down.
7. Select Include in Data File or Select from Default Value from Employee Type. When you click Select from Default Value, a drop-down menu is displayed from which you can select the required value. For file load, you should specify the Employee type code and Name.
8. Select Include in Data File or Select from Default Value from Home Budget Entity.
9. Select Include in Data File or Select from Default Value from Position Budget Entity.
10. Select Include in Data File or Select from Default Value from Account dropdown.
    Note:

    All the financial fields are mandatory. You can either select from a Default value or specify in the load file.
11. Select Include in Data File or Select from Default Value from Fiscal Year dropdown. When you click Select from Default Value from Fiscal Year, you can select the year from the calendar. Or, you can load from the load file.
12. Select Include in Data File or Select from Default Value from Fiscal Month dropdown. When you click Select from Default Value from Fiscal Month, you can select the month from the calendar.
13. Click Next. The Manipulate Input File screen is displayed.

Manipulate Input File Screen

You need not make any changes to this screen. Click Next to navigate to the Define Data Mappings screen.

Define Data Mappings Screen

You need to map fields in the Source Column to values available in the Maps To field drop-down lists. Click Next. The Load Data screen is displayed.

Load Data Screen

1. You can either choose a new Data file or click Finish.
2. Once you click Finish, you will either receive a Data Load success message or an exception report.
3. You can then navigate to Dynamic Reports and build your custom Variance Report.

Load Successful:

To update the existing data for the specified Actual Scenario, the Employee Number, Employee Name, and Position Description should always match. If the load file contains a combination of valid and invalid rows, the loading is progressive. In cases where the load is partially successful, invalid rows will be skipped, and valid rows will be loaded. For specific periods, users can load Actual amounts. The Actual DLR load is Synchronous.

Data Load Failure Cases:

While loading, if the segment members or periods information is missing in the load file, then the load will fail and an exception report will be generated. If the load file has a new employee that does not exist in any scenario, still the load will be successful and a new record will be created in the Actuals scenario if ‘Reference scenario’ is not selected. If the reference scenario option is selected and the load file has an employee whose details do not match with the Reference scenario, then a load of that particular employee will fail. If the load file has employees with all zeros provided for the amounts for all the specified months, such employees will be skipped from loading. Once the employee details are loaded to the Actual scenario, for subsequent loads for the same employee, the employee number, Employee Name, and Employee Position description should match respectively when no reference scenario is taken. If a reference scenario is taken, the metadata including emp type will be updated as per the Reference scenario into the actual scenario. If the data that exists in the Actual scenario has a mismatch with subsequent load data for “Home Budget Entity, Position Budget Entity” then the load would fail.

Example- Let's say for Alex,“ product management” is his “Home and Position budget entity” in the Actual scenario but if the next load has different details the load would fail.

Workforce Actuals: Webservices Load Type

You can use Webservices to load Workforce Actuals automatically. Once the Workforce Data load is complete, you will receive an email with the load status. This feature will help reduce the manual work of loading Workforce employee actuals and allow you to automate the loading process for any specified time period.

How to Use Webservices in Data Load Rules?

1. Navigate to Maintenance > Data Integration > Data Load Rules.
2. Click New Data Load Rule available in the side navigation.
3. Enter a Name for the Data Load Rule.
4. Select Webservices from the Load Type drop-down list. File Load and Copy-Paste are the other two Load Types supported by the system.
5. Select Workforce Planning as a Load Item from the drop-down list.
6. Select Workforce- Employee Actuals as a Load Sub Item from the drop-down list.

   

7. Now click Next. The Select Sample Input File screen is displayed.
   
   Select Sample Input File Screen:
   
8. Fill all the fields with specific data and click Next. The Define Overall Rule Settings screen is displayed.

   
   Define Overall Rule Settings Screen:
   

9. Fill all the fields with specific data and click Next. The Manipulate Input File screen is displayed.
   
   Manipulate Input File Screen:
   

   
   

10. You need not make any changes to this screen. Click Next to navigate to the Define Data Mappings screen.
    
    Define Data Mappings Screen:
    

    
    

11. You need to map fields in the Source Column to the values available in the Maps To field drop-down lists.
12. Now, click Next. The Load Data screen is displayed.
    
    Load Data Screen
    

    
    

13. Click Finish.
14.  Once you click Finish, you will receive a Data Load success message.
    

Actuals: File Load

The Workforce Actuals data load rule is now added under the flag Horizon_DataLoad_For_FileUpload. If the flag is enabled, the data is loaded in the Async mode. In the Async mode, you need not wait in the Load Data screen for the data load to complete. Instead, you can navigate to multiple screens and continue work while the data is being loaded.

A new ADC task is added to the Async load. Now, when you click Finish in the Load Data screen, the ADC task is submitted, and a notification confirming the task submission is sent. After the task is completed, you will receive a notification containing details of the load status. You can also see the detailed log of entries in the Job Manager screen. The data is loaded in Sync mode if the flag is not enabled. The Sync and Async functionalities work based on the flag status.

Employee Transfers in Workforce Planning

You can load employee actuals for employees transferred from one budget entity to another. Now, you can load two different budget entities with an employee, provided the entities have the same currency. In this case, the dynamic report will show different entries for the same employee consisting of different entities. 

How to Load Employee Actuals?

1. Navigate to Maintenance > Data Integration > Data Load Rules.
2. Click the New Data Load Rule available in the side navigation.
3. Enter a Name for the Data Load Rule and fill all the fields with specific data. 
4. Select Load Type. 
5. Select Load Item as Workforce Planning. 
6. Select Load Sub Item as Workforce- Employee Actuals from the drop-down list.
7. Fill all the fields with specific data in the following screens and click Next.
8. You can choose a new Data file or click Finish in the Load Data Screen.

Once the data load is successful, you can navigate to Dynamic Reports. In case there are multiple entities mapped to an employee having the same currency, your report will have multiple entries for the same employee.

Copy Over Home or Position Budget Entity Data in Actuals

As a part of Workforce Planning Actuals, you can map Home Budget Entity or Position Budget Entity to the load file and copy over the missing entity while defining the rules to load a DLR. Now, when you choose Home Budget Entity or Position Budget Entity, you can map the entity from the entity drop-down list instead of revisiting the file to enter the missing value.

The Home Budget Entity and Position Budget Entity contain the following options, and you can use the combination of options in these drop-downs that suit your needs:

• Include in Data File
• Select Default Value
• Copy Home/Position Budget Entity

How to Copy Data from Home or Position Budget Entity?

1. Navigate to Maintenance > Data Integration > Data Load Rules.
2. Click the New Data Load Rule available in the side navigation.
3. Enter a Name for the Data Load Rule and fill all the fields with specific data.
4. Select Load Item as Workforce Planning and Load Sub Item as Workforce- Employee Actuals from the drop-down list.
5. Fill all the fields with required data in the following screens and click Next.
6. In the Define Overall Rule Settings screen, fill all the other parameters with data.
7. In the Defaults section, select Include In Data File for the required fields
8. Select an appropriate option for Home Budget Entity from the drop-down. 
9. If you have selected Select Default Value, you can select a Home Budget Entity from the pop-up screen.
10. Based on the option selected for Home Budget Entity, select an appropriate option for  Position Budget Entity from the drop-down. 
11. Fill all the fields with specific data in the following screens and click Next.
12. You can choose a new Data file or click Finish in the Load Data Screen.