Workforce Insights | Setup

Before you can do these steps, your org needs to have CRM Analytics licenses in place.

Check your package versions

Before you begin, ensure you have the latest version of the following packages:

  • Workforce Insights

    If you are upgrading from a previous version, check the upgrade path. To ensure the Workforce Insights installed app update goes smoothly, updates to existing dashboard datasets and recipes are delivered separately from new recipes in separate package versions.

  • Human Capital Management (HCM)

  • Performance Management

  • Time

Note

In most cases, release packages will be installed for you by Sage People support. If you are unsure which package version you have, see Check your version of a Sage People package. If you need assistance with upgrading your org, contact your account representative following your usual support process.

For information about installing Workforce Insights and other packages, see Upgrading Sage People packages.

Embedded app creation after package installation

The package installation creates Integration User and Security User to your org if they do not already exist.

After the package is installed, the SP Workforce Insights Embedded app is automatically installed. The app installation takes some time to complete. You can monitor the progress of the app installation:

  1. Go to Setup, and in Quick Find enter apps, and select Auto-Installed Apps from the search results.

  2. Select the SP Workforce Insights Embedded to view the app installation progress on its app page. When the status displays Success, the app has been installed.

    If you do not see any apps on the Apps tab, select the Requests tab. If a request to install an app failed, it displays there: 

    Screenshot: A failed App Create request on the Requests tab

    If you have a failure, check and if necessary, update the permission set assignment for the Integration User, and select Try Again for the failed request.

Configure data connections for the Workforce Insights app

To enable data refresh in the App & Dashboards, you'll need to manually configure the apps data connections to use full refreshes. The default setting for data connections in production orgs is unsuitable for Workforce Insights dashboards because it only refreshes data when row counts change, ignoring changes to existing rows.

Ensure your admin user has the recommended permission sets to configure these correctly. For more information, see Workforce Insights | Permission sets.

To configure data connections:

  1. Go to the App Launcher.

  2. Go to the Data Manager app.

  3. Select Connections from sidebar menu.

  4. Select SFDC_Local.

  5. In the list of object connections, update to read "Full Sync".

  6. In each object, select Edit Connection Mode from the drop down menu.

  7. In Connection Mode, select Full Sync.

  8. Click Save.
  9. Repeat steps 1 to 7 for all objects in SFDC_Local connection.
  10. After you've completed this, click Refresh and check all objects are set with Connection Modes of Full Sync only.

Assign permission sets

To enable users to administer and access the dashboards, assign permission sets to users as follows: 

User or user group Permission sets
Integration User

This permission set is automatically assigned when the Sage People Workforce Insights Managed package is installed.

  • Sage People Workforce Insights Data Sync

If the permission set is not automatically assigned for any reason, you need to assign it. This permission must remain assigned to this user for Workforce Insights to be enabled.

System administrator and other administrators
  • Analytics View Only User

  • Sage People HR Administrator - Workforce Insights

  • CRM Analytics Platform/Plus Admin (Platform/Plus based on which license is purchased for the org)

Required to:

  • Install the Workforce Insights package

  • Access the Auto-Installed Apps page to check the status of SP Workforce Insights Embedded app installation

  • Access the App Install History page for scheduling data refresh

  • Access the Workforce Insights Policy Tab and Settings within it

  • Access the Data Manager to Configure the Data Connections

 

C suite dashboard users
  • Analytics View Only User

    Enables the user to view CRM Analytics dashboards they have access to.

  • Sage People Workforce Insights C-Suite Viewer

    Grants access to the WX process hosting the C Suite dashboards

Managers for the team lead dashboards
  • Analytics View Only

    Enables the user to view CRM Analytics dashboards they have access to.

  • Sage People Workforce Insights Manager Viewer

    Grants access to the WX process hosting the team lead dashboards.

  1. Go to Setup, and in Quick Find enter permission, then select Permission Sets from the search results.

  2. From the list of permission sets, select the permission set you want to assign.

  3. On the permission set page, select Manage Assignments.

  4. On the Current Assignments page, select Add Assignment.

  5. On the list of users, select the checkbox next to users you want to assign this permission set. Then select Next.

  6. On the Select an Expiration Option for Assigned Users page, leave No expiration date selected, and select Assign.

  7. On the Assignment Summary page, select Done.

Create a WX processes

The Workforce Insights package in the Y25.1 release delivers 5 WX processes:

  • WI CS Headcount, which displays the C Suite Headcount dashboard to WX users, with the correct permissions and policy settings.

  • WI CS Diversity, which displays the C Suite Diversity dashboard to WX users, with the correct permissions and policy settings.

  • WI Mgr Headcount, which displays the Manager Headcount dashboard to WX users , with the correct permissions and policy settings.

  • WI Mgr Performance, which displays the Manager Performance dashboard to WX users, with the correct permissions and policy settings.

  • WI Mgr TimeOff, which displays the Manager Time Off dashboard to WX users, with the correct permissions and policy settings.

  1. In the HR Manager Portal, select the WX Services tab.
  2. Select the WX Service you want to host Workforce Insights. To host it in its own service, follow the steps in Creating a new WX Service.
  3. On the WX Service Detail page, in the WX Processes Related List, select New WX Process.
  4. On the WX Process page, complete the fields as follows:

    Field

    Description

    Label

    The name you want displayed for Workforce Insights dashboards. The label is displayed:

    • In the Navigation Bar and the Service Bar.
    • On the Workforce Insights, if Show Title In Tile is checked.
    • On the Workforce Insights page, if Show Title in Detail is checked.

    Active

    Checkbox, checked by default to make Workforce Insights dashboards available for display in WX.

    WX Service

    The name of the Service you want to host this Process. By default, Sage People inserts the name of the Service you selected at the start of this procedure.

    Order

    Number, no decimal places. The order in which you want Workforce Insights dashboards displayed within the Processes hosted by the Service.

    Start Date

    The date you want Workforce Insights dashboards to be available.

    Leave blank if you want Workforce Insights dashboards to be available immediately.

    End Date

    The date after which you no longer want Workforce Insights dashboards to be available.

    Leave blank if you want Workforce Insights to be available indefinitely.

    Preferred Number Of Columns

    Number, no decimal places. The number of columns you want to use when displaying the Workforce Insights tile with other Processes in the same Service. Currently supports 1 or 2.

    Show In Mobile

    Checkbox. If checked, Workforce Insights is displayed by the Sage People Mobile app.

    Show Title In Tile

    Checkbox. If checked, Label is displayed at the top of the Workforce Insights Tile.

    If unchecked, the Tile does not include a Title bar.

    Show Title In Detail

    Checkbox. If checked, Label is displayed at the top of the Workforce Insights Detail page.

    If unchecked, the Workforce Insights page displays the default Custom Label Workforce Insights.

    The Show Title In Detail setting does not affect display of the Label elsewhere in WX - Label is displayed by default in Navigation Bar and Service Bar.

    Additional Information

    Leave blank.

    WX Process Type

    Picklist. Select:

    • WI CS Headcount for the C Suite Headcount dashboard

    • WI CS Diversity for the C Suite Diversity dashboard

    • WI Mgr Headcount for the Manager Headcount dashboard

    • WI Mgr Performance for the Manager Performance dashboard

    • WI Mgr TimeOff for the Manager Time Off dashboard

  5. Select Save.
  6. Repeat the steps for the other WX process.
  7. If you have previously configured the Workforce Insights process, deactivate or delete it to avoid confusion.

Refresh the dashboards

The dashboards do not use data from your org directly, but from the datasets. When data in your org changes, the dashboards are updated when the datasets are refreshed. The free Analytics View Only Embedded App license enables data to be refreshed once in a 24 hour period.

You can schedule a refresh or run it manually.

To refresh the dashboards: 

  1. Go to Setup, and in Quick Find enter apps, and select App Install History from the search results.

  2. For SP Workforce Insights Embedded app, select the down arrow on the right and: 

    • Select Schedule to schedule a regular refresh:

      Screenshot: Schedule CRM Analytics app refresh

      Select the Start at picklist and choose the time of day when you want the refresh to start. Then for Run on, select the days of the week when you want the refresh to run. When you have set the schedule, select Save.

      The time for starting the next refresh is displayed in the Next Refresh column.

    • Select Refresh Now to run the refresh immediately.

      Sage People displays the Refresh Data dialog:

      Screenshot: Refresh Data dialog

      Select OK.

      The refresh starts and you can view the progress in the Task Overview column:

      Screenshot: App history with data refresh task overview

      You can select Refresh to monitor the progress of the data refresh.

  3. After scheduling a refresh, you can: 

    • Select the down arrow on the right and then Delete Schedule to remove the current schedule.

    • Select the down arrow on the right and then Schedule to make changes to the current schedule.

Workforce Insights app upgrades

The SP Workforce Insights Embedded app is delivered with the Auto-Upgrade setting set to enabled. This means Sage People can automatically deliver new dashboards and updates to the existing dashboards to the app when a new version of the Workforce Insights package is released—you do not need to do anything to receive the updates. Sage People recommends you do not change the default setting.

If you make changes to the dashboards delivered by the SP Workforce Insights Embedded app, an upgrade will overwrite your changes. For this reason, if your organization wants to create your own dashboards, the recommended way of using the Sage People delivered dashboards as a starting point is to clone the dashboards in the CRM Analytics Data Manager, and make all edits to the clones rather than the original dashboard. This means the original dashboards can receive updates without disrupting your own dashboards. Developing your own dashboards requires paid licenses for CRM Analytics.

If you want to switch off automatic upgrades:

  1. Go to Setup, and in Quick Find enter apps and select Auto-Installed Apps from the search results.

  2. Select SP Workforce Insights Embedded from the list of apps.

  3. From the Details section, select App Settings

    Screenshot: Selecting App Settings

  4. Clear the checkbox next to Auto-Upgrade. Then select Save.

Automatic upgrades are no longer enabled, and your org will not receive updates to the dashboards in the SP Workforce Insights Embedded app from Sage People.

Permission sets and policy settings

The Workforce Insights package in the Y25.1 release delivers five WX processes and new policy settings for each one. The policy settings for the Workforce Insights processes is under a tab on the Policy details page. Clicking this tab will allow you to view and edit the policy settings for WX Processes, with each of these new settings disabled by default.

To set a User's Policy to show in Workforce Insights dashboard:

  1. Select the user you want to view.

  2. Click View Policy.
    screenshot of WX - Workforce Insights user policy

  3. Select the Workforce Insights tab.
    screenshot of the workfoce insights tab

  4. Click Edit.

  5. Select the dashboard settings you want to show to the user.
    screenshot of WX - workforce insights dashboard ticks

  6. Click Save.

This table shows the Permission sets and Policy settings required for each process to be displayed to a user in WX.

Process Type Permissions Set Policy Setting
WI CS Diversity Sage People Workforce Insights C-Suite Viewer WI CSuite Dashboards > Display Diversity
WI CS Headcount Sage People Workforce Insights C-Suite Viewer WI CSuite Dashboards > Display Headcount
WI Mgr Headcount Sage People Workforce Insights Manager Viewer WI Manager Dashboards > Display Headcount
WI Mgr Performance Sage People Workforce Insights Manager Viewer WI Manager Dashboards > Display Performance
WI Mgr TimeOff Sage People Workforce Insights Manager Viewer WI Manager Dashboards > Display TimeOff

Ensure dashboards display data

Some of the dashboards require you to enable optional features or use specific fields to feed data for the dashboards:

  • Team lead dashboards, Time Off tab, Team health section:

    • Cards and charts use the Absence Day Record object. For more information about enabling the creation of absence day records in your org, see Absence and Vacation | Day-by-day breakdowns of absence records for reporting.

    • Cards, charts, and tables use the Is Sickness Absence checkbox field in the Absence Accrual Rule object to define which absences are sickness absences and which are not.

      Follow the steps in Page layouts, search layouts, related lists to add the field to the Absence Accrual Rule page layout. Then review the absence accrual rules in your org. For any rules you want to count as sickness absences for Workforce Insights dashboards, edit the rule to select the Is Sickness Absence checkbox, and save.

Dashboard sharing settings

By default, the SP Workforce Insights Embedded App is shared with the entire organization with View access. This means everybody in the organization who is assigned the Analytics View Only User permission set can view the dashboards, if they have access to the dashboard URL or a page hosting the dashboards.

Users with CRM Analytics Platform/Plus Admin permission sets can modify this sharing rule within the CRM Analytics app. However, this is not recommended because it reduces visibility for administrators and may cause hard-to-decipher errors. For example, errors might occur in WX if Team Members are assigned a Workforce Insights Process within this Policy and Permission Sets but the WI App is not shared with them. Additionally, upgrade installs for Workforce Insights will override any changes made to the App Sharing Rules and re-apply view sharing with the entire organization, as this is the recommended approach for the WI Dashboard Experience.