Administering WFA on SAP HANA

This unit looks exclusively at tools available for WFA on SAP HANA. Customers with WFA on SQL server will not have access to these tools. For more information, check the Workforce Analytics on SAP HANA FAQ document on the SAP help portal.

Workforce Analytics Drill to Detail (DTD) enables appropriately permissioned users to drill down to the individual employee records that comprise the selected result.

Drill to Detail is available in table/pivot views by default on standard Measure pages and can be made available by report designers in table views on custom report pages. When viewing a measure results in a table, Drill to Detail is available if the cursor changes to a hand (indicating a clickable link) when hovering over an individual result. In the example above the Drill to Detail results will show the employee records that comprise the Average Age of 34 for Physically Challenged employees in Australia.

Drill to Detail will automatically exclude columns from the view if they are not applicable for the selected measure. For example, if the Recruitment Source dimension columns are included in the DTD configuration, they will only be displayed when using DTD on Movement In type measures. They will not display when DTD is used on certain other types of measures such as Headcount measures.

To open the WFA on HANA Admin tool, navigate to Admin link on the Workforce Analytics page and select the tool.

1. Select whether to configure the DTD display for Measures.

2. Key columns that can be included in the DTD display.

3. Dimension columns that can be included in the DTD display.

4. Attribute columns that can be included in the DTD display.

5. List of columns currently included in the DTD display.

6. Edit (relabel and/or set BizX User column) and Remove column/s.

7. Change the order the columns appear in by Move up or Move down.

8. Choose how the records in the DTD results are sorted.

9. Mark a column as a sensitive field for read logging.

Select from key columns, integral to the measure results.

Select from columns related to each dimension. The list of available dimensions available will change in accordance with what is currently implemented in the instance.

The Level X ID/Name columns in a dimension allow you to display that dimension’s structure as part of the DTD results.

For example, you can see that the employee in the first record (User Sys ID = 100095) is in the Philadelphia location, which rolls up through Newtown Square > Pennsylvania > United States.

Attribute columns contain the list of columns that are attributes to related dimensions. The list of available attributes will change in accordance with what is currently implemented in the instance.

Code: Displays the ID/Code of the attribute for its related dimensions.

For example, you see that these two employees (User Sys ID = 107026 and 107023) have Pay Component code BASE_CN and Frequency code of MON for their Total Workforce Annual Salary.

Drag and drop to add new columns to the DTD display.

If adding a Level X column, choose which level of the dimension you wish to use.

Column Info will show the level selected.

Select a column and click edit columns to change its display label or mark as sensitive for read access logging.

Relabeled columns will show a Column Display Name.

Select the column that contains the employees User Sys ID, select Edit columns and check Is BizX User ID to enable the Profile Preview on that column in the DTD results.

This column will now appear with the Profile Preview link in the DTD results.

Change the order of columns in the DTD display using Move Up and/or Move Down.

Choose which columns the DTD display will be sorted in Order Drill to Detail Results.

Dimension Editor allows Workforce Analytics on SAP HANA or Analytics in Employee Central Admins to manage their Dimensions – including changing where dimension nodes are placed in the dimension and/or adding labels to dimension nodes.

Only dimensions that are configured as Manually Maintained during the WFA implementation process can be edited using Dimension Editor.

You can Access Dimension Editor WFA Dimension Editor in the Admin Center:

This table lists the frequently used words and terminology in Dimension Editor:

Standard nodes are default nodes automatically generated within dimensions and are used to identify dimension nodes required for selected measures.

You can manage which employees are included in certain measures by ensuring the right mapping of nodes into these default standard nodes. For example, to ensure all temporary employees are included in the EOP Headcount – Temporary measure, map any Employment Type codes for temporary employees into the #TEMP node in the Employment Type dimension.

Each time the WFA on HANA data is processed, it will identify and collect any new codes in the data and assign them into the Unmapped parent grouping in the dimension to which the node belongs.

It is recommended that the dimensions in the Dimension Editor are frequently reviewed for the Unmapped grouping and any codes within are remapped to their appropriate parent or place in the dimension.

You can use dimension editor to configure you structural and analysis dimensions. The following sections outline those actions.

To relabel a node, click in the Long Name field and type in the new label.

To move a node to a different parent, perform the following steps:

1. Choose the node.

2. Select Move Node.

3. In the pop-up window choose which parent to move the node to.

4. Select Move.

For example, Remapping the No node from the Unmapped parent to the Non-Physically Challenged parent.

Sort ascending or descending sorts by the node label, the children of the node selected.

Move up and move down moves nodes up or down the ordering within their parent grouping.