Overview of Workforce Planning data integration Designer-based

Table-based integration does not require Infor ION, Infor Business Vault, or Infor Business Vault Base Data Store.

Infor d/EPM supports the storage, analysis, and reporting of Workforce Planning data. To describe and organize this data for use by Infor d/EPM, structures are built in OLAP databases. The OLAP databases are known as models or cubes, and are formed by some number of dimensions, which are lists or hierarchies of dimensional elements. Like the rows, columns, and tabs of a spreadsheet, these dimensions provide the means to store and retrieve employee information such as their assignment, working FTE, and other types of data value, such as workload volume.

Data and the required dimensional elements and structures can be loaded in a variety of ways.

This section describes importing from standard Microsoft SQL Server tables. For some scenarios and environments, this can be a relatively straightforward approach, using commonly understood database column mapping and SQL scripting concepts.

Stored procedures within the Integration database can be modified to allow for customized data integration for more complex integrations.

This table-based integration is intended for the initial bulk load of dimension structures that occurs at the beginning of the budgeting process to initialize the system and for the regular data load. The data load includes the employee and workload information, such as the expected and actual production volumes. Changes to the structures can be made by doing additional imports on existing content and selecting to update the existing elements and hierarchies.

The table-based integration process requires the use of Designer to update the Designer database and to recreate the OLAP database.