The Report Generator reports to extract the raw data for Advanced Analysis are written in each individual module's Report Generator.
The TITLE COMMAND must be written with the following flags included:
Title: A meaningful title for the report.
Output: N for None.
Kerridge product: For Kerridge use only.
Update file: The number of the Raw file in the Files command. This is the raw file that the report will update when it is run.
You have to be priority 8 or 9 to have the Update File field shown to you. .
The Update of the Raw files is determined in the Update command of the Report Generator.
Use the Files command to specify the files used to extract data for the report. See Report Generator manual.
The Raw data file that the report will update will also be specified in the File command:
00.AA.rawST
For further details on file linking or connections, see the Report Generator manual.
To initialise the output file (raw file) before writing to it, include the line rg_initfile = true in the derived fields logic of the report.
|
Name |
= |
|
rg_initfile = rawxx |
Where xx is the topic code.
Multi-companies: If the Topic is dealing with multi-companies, then include the following lines in the Derived Logic and Update command.
|
Name |
= |
|
Company$ |
rg_Company$ |
and in the Update command
|
L |
Code |
|
N |
!3_COMPANY=RG_PREV_UD_COMPANY$ |
The Update command lists the Raw file fields that are going to be updated by the report.
The raw files fields are updated by assigning an extracted value to individual fields.
To assign a value to a raw files field, it is necessary to use "=".
For example:
|
L |
Code |
|
N |
!3_SUPPLIER = !1_ACCOUNT |
Thus the raw data field SUPPLIER will be updated with file 1's (BR.prodf.dd) ACCOUNT.
For Advanced Analysis to work, it is imperative that the Update command of the Report Generator includes the following:
Sequence++: The update must set the raw data field "sequence" to a value of Sequence++, this is so that each KISAM record has a unique key.
A Date field: At least one date field must be extracted by the Report Generator, and that date field must update a raw data file Date field.
The raw data Date will be the field that is being used as the Date field in the Advanced Analysis Profile => Field. Consequently, this will be the Date that determines in which period on the Timeslice each value will be included.
An Inclusion field: The Inclusion field must be included in the Report Generator update of the raw data file.
Note: To optimize the 16 bytes allowed down each axis, a portion of a field may be used and written into a raw data field by using some derived logic in your report.
For example: !2_Partno = Str (!1_Partno,3,2)
Thus placing the value of bytes 3 and 4 of !1_Partno into !2_Partno
For more information on the Report Generator, see the Report Generator Manual.
The running of the Advanced Analysis can be done successfully in the End of Day routine.
Note: The Report Generator update reports must run in a batch that runs before the End of Day routine starts.
Use a batch that runs pre-end of day.
If all the reports are placed in a batch then the Advanced Analysis will run correctly and the results will be relevant, because that data will have been updated currently.
Rebuild frequency: You can instruct the EOD to rebuild the drill-down file Daily, Weekly or Periodically.
The Process raw data procedure can be part of the End of Day routine.
Assuming that the reports that update the Raw Data files are run in the pre-end of day run, then the procedure Process raw data, which produces the Formal Files, can run automatically in the End of Day routine.
The process Generate drill down files can be part of the End of Day routine.
Assuming that the reports that update the Raw Data files are run in the pre- End-of-Day batch, and the Process raw data procedure has terminated correctly, then the procedure Generate drill down, which produces the drill down files, can run automatically in the End-of-Day routine.
This option is only available in Timed Operations.
It is designed to be scheduled as an interval option in addition to the 2 previous options which run overnight. It can be run throughout the day so that the drill down files are always up to date. The reports which update the raw files must also be run at the same frequency.
