Ad-Hoc Query Layer

The Ad-Hoc Query Layer includes a wide range of reportable objects from the Infor Workforce Management database. The Ad-Hoc Query Layer is divided into namespaces based on business concepts. Each namespace is designed to meet all the reporting requirements that are relevant to its business concept.

Each Ad-Hoc Query Layer namespace uses a particular join strategy to connect query subjects. This is important because there may be multiple ways to link together subjects such as employees and jobs, depending on the business context. Different sets of query subjects are presented in the Ad-Hoc Query Layer, depending on which package the report author has loaded.

This table lists the packages that are available with Workforce Performance:

Metadata Package	Description
WFMStandard	The WFMStandard package is used for developing general-purpose reports and queries. The WFMStandard package is the default package loaded when creating custom reports and queries in Workforce Performance. Most of the standard reports provided with the application are based on this package.
WFMBurst	The WFMBurst package is used for building burst reports. Burst reports can be displayed on users' launch pad when they access the application. The sample Cognos launch pad components use the WFMBurst package. The WFMBurst package uses a similar structure to the WFMStandard package, but it handles user and team information differently. This package organizes the data by burst key instead of filtering for the user running the report. This allows a burst report to be executed once with the output tailored to multiple users.
WFMRetail	The WFMRetail package is used for developing burst reports specifically for the Labor Forecasting and Scheduling Optimization (LFSO) module.
WFMSystem	The WFMSystem package is used to report on system administration data, such as audit data and import and export processes.
WFMReportAudit	The WFMReportAudit package is used to report on the usage of Workforce Performance reports, such as on how long a report takes to execute.