- 7 Minutes to read
- Print
- DarkLight
- PDF
Workforce Reporting
- 7 Minutes to read
- Print
- DarkLight
- PDF
Overview
Workforce Reporting enables structured, ad hoc analysis of workforce planning dimensions and measures. Workforce Reporting is integrated into the application as a Reporting Area, allowing you to report on employee-specific compensation and other financial dimensions, such as:
Head count analysis
Variance analysis
Payroll analytics
Requisitions for hire
Promotion tracking
Workforce planning reports are more flexible, and significantly quicker to generate, compared to customized Standard Reports.
Workforce Reporting Dimension and Scenario Security
Workforce Reporting inherits the Dimension Security applied to the Financial Reporting Area, for dimensions such as Company, Department, Project, etc.
Data is filtered according to user privileges for dimensions. You can also activate dimension security for each user by navigating to Maintenance > Reports > Dimension Security > Dimension Security Setup and assigning users to specific reporting areas.
Apply Dimension Security so that Scenario Security is honored in the Workforce Reporting Area by navigating to Maintenance > Reports > Dimension Security > Dimension Security Configuration, and selectingCopy Scenario Security to Report Security.
How to Enable Workforce Reporting
Click Maintenance > Admin > ConfigurationTasks.
From Define Reporting Areas, click Workforce. Once the cube is created, the icon changes to green, and Workforce Reporting Area is enabled (processing is required in order to view the data).
Workforce Reporting Dimensions
The dimensions for the Financial Reporting Area (Time, Org, etc.) are also common to the Workforce Reporting Area. Several dimensions have been added specifically for Workforce:
Employee
Position
Employee Type
CompensationItem
Home Budget Entity
Position Budget Entity
Click on the Point of View (POV) target icon in the upper right corner of the application to launch the Point of View screen, then select Workforce from the Reporting Area pull-down menu to see all available Workforce dimensions. (You can edit dimension default members from the Default Members screen.)
Workforce Reporting Cube Structure
The following illustration shows the interrelationship between dimensions and measures in the Workforce Reporting cube:
Workforce Attributes
Workforce attributes and properties are defined in the application as Measures.
Properties, Attributes, and Attribute Hierarchies mapped to the Financial Reporting Area (accessed via Maintenance > Reports > CubeSettings > Attributes Settings) are shared and available in Workforce Reporting Area.
Workforce Measures
All the HR attributes available in Workforce Planning are available for reporting as Measures when the Workforce Reporting Area is enabled. Note that if Multiple Review Dates are used in Workforce Planning, only the first Review Date is available.
After a cube is created, the following measures (sorted by category) are available for use in reporting:
Category | Measures |
Employee Fact | Hire Date Process Status |
Position Fact | Position End Date Position Pay Plan Position Start Review Type Salary Class Wage Rate per Hour Work Hours per Month Annual Salary * |
Workforce | Allocation Percentage * Amount in CC * Amount in LC * Amount in Position Entity Currency * Head Count * |
You can map measures as follows:
- Navigate to Maintenance > Reports > Cube Settings.
- Click the Attribute Settings tab.
- Select Workforce as the Reporting Area.
- From the Mapped Measures list, click the Add icon. The Select Measures screen appears.
- Locate the measure and select it.
- Click Add Selected. The measure is added to the Mapped Measures list. (To unmap an attribute from the list, select it and click the unmap [X] icon.)
Workforce Default Members
Default Members are applied when the respective dimensions are not selected in the report design. You can edit default members, if desired via the Maintenance > Reports > Cube Settings > Default Members screen.
Since the Default Member for the dimensions is All or the root node of the hierarchy, if any non-aggregatable measures are used in the report design, it is required to include all the dimensions in the report design.
Workforce Report Generation
Workforce Reporting functionality is integrated into Dynamic Reports, Report Sets, Report Collections, and Financial Package Publisher (FPP) as a Reporting Area, thereby enabling structured, ad hoc analysis of workforce planning dimensions and measures. This allows for reporting on employee-specific compensation and other financial dimensions.
Workforce Reporting Best Practices
When creating Workforce reports, be sure to:
Apply appropriate filters to limit the size of your reports
Include all relevant dimensions in the report design for the business case for greater accuracy
Use Workforce applicable dimensions when building calculated or custom report members
Workforce - Dynamic Reports
With Dynamic Reports, you can create ad hoc, structured reports for specific dimensions, which can also be used to generate Report Sets. You can build and run a wide variety of dynamic reports.
You can, for example, create a head count dynamic report which shows departmental head count variance (i.e., forecast v. actual) for your current fiscal year, prior v. current year, and so forth.
You can build a dynamic report for compensation (salary, bonus, etc.) by department, employee, employee type, or other Workforce dimensions.
An open new hire requisitions by department dynamic report can be generated to show quarterly head count openings, by department, as well as reporting on the status (open, approved, etc.) for specific positions.
Workforce Report Sets
You can create and generate Report Sets from Workforce-specific dimensions, based on the row or column axis of a Dynamic Report.
Workforce - Financial Package Publisher (FPP)
Financial Package Publisher (FPP) utilizes content from internal and external sources to generate Word or PowerPoint multi-page reports that can be distributed across your organization.
You can include Dynamic Reports created with Workforce Planning data in your Financial Package.
How To Report on a Workforce Scenario
Navigate to Maintenance > Reports > Process Reporting Area.
Select Workforce as the Reporting Area.
Check the scenario you want to report on.
Click Process Now.
Run the report.
When Measures Aren't Displayed in Your Workforce Report
There could be various reasons why measures aren't displayed on your report:
Ensure employees are processed and the corresponding scenarios/partitions in the cube are processed/published.
Ensure all calculated members used in reporting for Account dimension are built only on the dimensions that are exposed in Workforce Reporting. If not, usage of such calculated members will result in MDX errors.
Based on the measure applied in the report, pull all the linked dimensions.
For non-aggregated (all measures excluding Annual Salary, Amount in CC, LC, PositionEntityCurrency, Head Count) measures, ensure only leaf members are selected in the report.
When using the Head Count measure, Scenario and Compensation Item on the Page axis, ensure single leaf member selections are made.
Workforce Reporting Budget Entity Security
Data displayed in Workforce Reports is controlled using Budget Entity security, as configured via Maintenance > Admin > User Management, Approval Role Setup page.
Workforce Reporting Template Access Security
HR data is displayed in Workforce Reports only if the user has access to Workforce Planning for a given budget entity. To provide Workforce Planning access for an employee:
Navigate to Maintenance > WFP > Workforce Planning Setup.
Select the Budget Entity you want to provide access to.
Click Employees > Employee Positions > Add.
Enter user information, then click the Save icon.
Reports Security
Provide security to users and user groups for Workforce Reports by navigating to Maintenance > Admin > User Management > User, selecting a user from the list, then clicking More > Report Access.
Security Example for a User with Specific Access
The following table lists example security settings for a user named John Doe—approval role, scenario access, and so forth. Additionally, the navigation path to the page where the settings are located is provided.
In this example, with these settings, Workforce Reporting security is honored for Dynamic Reports, for the given scenarios and budget entities, in the following ways:
For Budget 2017 Scenario:
1000-HQ-Exec—John Doe cannot access any employee data as the Approval Role on this Budget Entity does not have HR Template mapped.
1000-HQ-MKTG—John Doe can access Salaries and Bonuses data for all employees for this Scenario and Budget entity combination. However, he cannot view Non-Cash Stock Compensations and Benefits for the employees.
1000-HQ-HR—John Doe cannot access any employee data as HR template mapping does not exist for this Scenario and Budget entity combination.
For Forecast 2017 Scenario:
1000-HQ-MKTG—John Doe cannot access any employee data, even though HR Template is mapped to the given Scenario and Budget Entity combination, because he does not have access to Forecast 2017 scenario.