Populating the Data Mart
You must populate the data mart before accessing the interactive report pages.
Note: If the data mart contains no data, a search page appears when you try to access an interactive reports page, but you can't progress from there.
This topic discusses how to populate the data mart.
|
Page Name |
Definition Name |
Usage |
|---|---|---|
|
RUN_SPR_DM |
Enter parameters that are used to run the PeopleSoft Application Engine that populates the data mart for analysis purposes. |
Use the Analysis Datamart page (RUN_SPR_DM) to enter parameters that are used to run the PeopleSoft Application Engine that populates the data mart for analysis purposes.
Navigation:
This example illustrates the fields and controls on the Analysis Datamart page. You can find definitions for the fields and controls later on this page.
Field or Control |
Description |
|---|---|
Business Unit |
Define the business unit for which you want to retrieve interactive report data. |
Run for UserID and Run for all Spro Users |
The system retrieves data and populates the data mart with data that is specific to the selected user. Select the Run for all Spro Users check box to retrieve data for all users. The current user appears as the default value in the Run for UserID field. |
Duration Date and # of Reporting Months |
The system uses the duration date in conjunction with the number of reporting months to determine the time period that is used to retrieve the interactive report data. Enter the number of reporting months to define the number of months before or after the duration date for which you want to retrieve data. Enter a positive value for number of reporting months to indicate the number of months starting from the duration date that are to be included in the process. Use a negative number to indicate the number of months prior to the duration date that are to be included in the process. Note: The system does not retrieve dates prior to the entered start date regardless of the entered duration date and number of reporting months. |
Use Current Date |
Select to define duration date as the current system date. If this check box is selected, the system uses the number of reporting months that are relative to the current system date for each process instance. |
Length of Stay
You enter data in the Length of Stay group box to define the parameters that are used to retrieve data for the length-of-stay interactive report pages.
Field or Control |
Description |
|---|---|
Length of Stay (Months) |
Enter the duration that a service provider can stay on assignment in accordance with the laws that govern the organization's labor practices. The system default is six months. The system uses this value for analysis calculations, including determining the excess duration on the length-of-stay interactive report pages. |
As Of Date |
Select the date for which the service provider is considered active. |
Leave Period (months) |
Enter the maximum allowable period between the end of a project and the start of the next project. This is used to determine the service provider's start date. |
Process Results
The Process Analysis Datamart Application Engine process (SPR_DATAMART) retrieves data from transaction tables and copies it to a fact table that is used during analysis.
Note: You can define a regular processing schedule by using the Process Scheduler page.
See the product documentation for PeopleTools: Process Scheduler