Create a WX Report entry

Create an entry for the report in the WX Reports tab. Use this entry to define the default settings for the report when it is displayed in WX.

You can use an existing Sage People or Salesforce report and display the report in its existing form, or further customize it for display to your managers or team members through WX.

  1. In the HR Manager Portal, select the WX Reports tab.
  2. On the WX Reports Home page, select New.

    Sage People displays the New WX Report page:

    Screenshot: new WX report page

  3. Complete the fields as follows:
    FieldDescription

    API Name

    The API name of the report, entered as the Report Unique Name when saving the report. To find the Report Unique Name for a saved report:

    1. Select the Reports tab
    2. Select the folder hosting the Report
    3. Select the Report Name.
    4. On the Report page, select Edit.
    5. On the Report Preview page, select the drop-down arrow beside the Save button, and select Report Properties.

      Screenshot: report properties

    The Report Properties dialog displays the Report Unique Name for the report.

    1. Select the Reports tab
    2. Select the folder hosting the Report
    3. Select the Report Name.
    4. On the Report page, select Edit.
    5. On the Report Preview page, select the drop-down arrow beside the Save button, and select Report Properties.

      Screenshot: report properties

    The Report Properties dialog displays the Report Unique Name for the Report.

    Object Name

    Required for Custom Report Types.

    The API Name of the lowest level object used to source the data. For example, for a custom report based on Team Member > Employment > Benefit enter:

    fHCM2__Benefit__c

  4. Select Save.

Sage People displays the WX Report Detail page for the Report:

Screenshot: report details page

To edit the WX Report:

  1. Select Edit.

    Sage People displays the WX Report Edit page:

    Screenshot: WX report edit page

  2. Complete the fields in the Information section as follows:

    Field

    Description

    WX Report Name

    The Report Name entered when saving the report. You can change the WX Report Name if you wish.

    API Name

    The Report Unique Name entered when saving the report. You can change the API Name to reference a different report but it must be a valid API Name for an existing report.

    Description

    The Report Description entered when saving the report. Edit the description if you wish.

    Type

    The Report Type, defined by the underlying report. One of:

    • Tabular
    • Summary

    Base Object

    The API Name of the lowest level object used to source the data.

    There are some limitations on Base Object, imposed by the nature of the relationships between some objects:

    • For WX Reports using data from Team Member, Employment Record, and Salary objects, set Base Object to fHCM2__Employment__c
    • For WX Reports using data from Team Member, Employment, and Absence objects, set Base Object to fHCM2__Absence__c

    Chart Default

    Picklist. Select the picklist and choose the chart type you want to display by default when the report is selected for display in WX:

    • None

      Defaults to Table.

    • Table

    • Line Chart

    • Vertical Bar Chart

    • Horizontal Bar Chart

    • Pie Chart

    • Doughnut

    • Radar Chart

    If the report cannot be rendered using the Chart Default, the report is displayed in Table format.

    Show Data For Team Member

    Checkbox. If checked, the report includes data for the manager viewing the report.

    Show Data for Report Levels Down

    Picklist. The number of organizational reporting levels included in the report, below the manager viewing the report. A value from 0 to 10.

    Note that this setting is not supported for reports that use the Job History object.

    Filter Logic

    The logical relationship between the filters listed in the WX Report Filters Related List on this page.

    For example, for a report using multiple filters:

    Screenshot: WX report filters

    ...Filter Logic might include:

    1 AND 2 AND (3 OR 4) AND 5

    where the numbers represent the value in the Order column in the Related List.

    If Filter Logic is blank, AND is assumed.

  3. Fields in the Advanced Options section control the visibility of the WX Report. Complete the fields as follows: 

    Field

    Description

    Show In Team Member

    Not used.

    Show In Team

    Not used.

    Policy

    Policy Name. To restrict visibility of this report to Team Members assigned to a single Policy, enter the Policy Name. Use Policy Lookup to find and select the Policy Name if necessary.

    Policy Group

    Policy Group Name. To restrict visibility of this report to Team Members assigned to Policies in a specific Policy Group.

    Team Member

    Team Member Name. To restrict visibility of this report to a single Team Member, enter the Team Member Name. Use Team Member Lookup to find and select the Team Member if necessary.

    Level Down

    Number. Use with Team Member to restrict the visibility of this report to the Team Member and a number of organizational levels below the Team Member. For example, for named Team Member and their direct reports, enter 1.

    Note that this setting is not supported for reports that use the Job History object.

  4. Select

    • Save to save your changes and return to the WX Report Detail page.
    • Save and New to save your changes and return to the New WX Report page to define another WX Report.
    • Cancel to discard your changes.

The WX Report Fields and WX Report Filters Related Lists enable you to change:

You can apply these changes to an existing report exclusively for display in WX - the underlying report remains unchanged.