Table of Contents
CREATING A NEW WINDWARD REPORT#
Objectives#
- Create a new Departmental Birthday report
- Add a parameter to select a specific month
- Add a lexicon to the month parameter
- Create a Department Head Count report (based on RENA)
Creating a Birthday Report#
IMFN#
- Create a new function for this report.
Any report run from within ePersonality must be defined as a function in the IMFN screen. The first two reports will be retrieving data from the HR tables only and is similar to the RENA report.
- Enter REBR for the function name and add a description for this report.
This demonstration will create a report named REBR. This follows our standard report naming convention. The 'R' indicates a read only report. This will not make any changes to existing data within the database. 'E' represents it is a member of the HR employee module, and 'BR' is an abbreviation for a Birthday Report.
Since this report is displaying employee information only, it should be part of the HR prod¬uct group.
- Set the following fields:
- Function Type to ‘Report’
- Usage to ‘User Defined’
- Computer Language to ‘Winward’
- Where Run to ‘Windward’
- Destination Format to ‘PDF’
PDF is the only supported output format at the time this demonstration was written.
- Add at least one user or role that will have execution rights to the new report.
Adding P2K_MASTER will allow P2K to run the report. If this report will prompt to users to enter parameters, both the Retrieve Allowed and Update Allowed toggles must be turned on.
IMFDH#
After the function has been defined in IMFN, go to the IMFDH screen. This screen defines the report parameter screen layout as well as all the tables the report needs access to.- Table Usage tab
- Add P2K_AM_EXECUTIONS in the Data Source field and set the Where Clause field to ‘NEW MEX ID ONLY’
- Add P2K_HR_ASSIGNMENT_DETAILS in the Data Source field
- Set the Table Usage field to ‘User Defined’ for both of these tables.
- If you are creating a report that is accessing the same table twice for different information the Table Alias and Join Clause fields are required for the second occurrence of the table.
- Form Layout tab
- Since we will be adding parameters to the report at a later time, we can ignore the Form Layout tab. This tab is used to define what parameters and filters are presented to the user and where they appear when the report is launched.
- Menu/Drill Downs tab
- The Menu/Drill Downs tab will be used later to add our report to the HR menu. During development and testing of the report we will simply run the report from the command windows within EP.
Report Template#
Once the function and form definition has been saved, a report template will need to be created.- Open MS Word and create a new Rich Text Format RTF document named REBR.rtf. This file is case sensitive; the file name must be in uppercase while the extension must be lowercase.
- Create a title for the new report and insert a table to format the column headings and data of the report. The table only needs to contain three rows with five columns each. Our report will contain the employee name, person code, gender, birth date and age. The entire second row will be blank to provide space between these headings and the data.
http://argo.highlinecorp.com/selfService_AS01/reportdatastructure?NAME=REBR This is an example using the AS01 instance in High Line's ARGO application server. The application server and instance name will need to be changed to point to a local environment.
The extension on this URL NAME=REBR is used to identify which tables the report will have access to. Each function will have access to a different set of tables as defined in the IMFDH screen earlier.
Once the XML data source has been defined, Auto Tag will have access to these tables as well as:
- P2K_AM_EXECUTIONS (MEX)
- P2K_AM_EXECUTION_RUN_LOGS (MRL)
- No InterWiki reference defined in properties for Wiki called "P2K_AM_USERS (MUS) *[P2K_AM_FUNCTIONS (MFN) *[P2K_AM_SITES (MST) These five tables are added to the data source of all reports generated by High Line and the items within them can be used in the report in the same way as any other item. If the data source provided to the template only contains one piece of information, it can simply be added to the report using an OUT tag. However, most reports will need to display several rows of information, sorted by one or more items. In this situation, a FOREACH tag will be needed to look through the data to display all the rows that pass the selection criteria defined within ePersonality. The Birthday Report needs to group all the employees for a department together and then present these employees alphabetically within each department. This will require two FOREACH tags to define this sort order correctly. Every FOREACH tag requires an END tag to close it. Failing to add an END tag will cause the report to generate an error when it's processed. Trouble shooting this type of error can be very difficult to do. It is recommended that an END tag be placed in your template immediately after creating a FOREACH tag to ensure each one has a corresponding end. The basic layout of this template will be"!, but there can be XLSX and DOCX as well. During the installation and configuration of the Oracle Application Server, a copy of these files would have been placed in the REPORTS folder under the HLAppResources directory used by each ePersonality instance.
The new statement is:
The only difference in these two statements is the addition of:
This sub-query will restrict the records reported to only employees that have an employment status of ACTIVE, REGULAR or PROBATIONARY. This will eliminate all terminated and inactive employees from our report. The final step to complete this report is to add the report to the application server, removing the need to upload the template each time we want to run the report. In order to add the report to the application server our custom RTF file will need to be moved into the UserDefined directory in HLAppResources/reports. This will require a user with write permission in this directory. We can test this again by running the RENAC report and not uploading our modified version. The Windward report engine should pick up the new template from this directory and run successfully.