This chapter contains the topic:
The process of bursting and binding depends on specific criteria being on the report. However, you might be working with a report that does not contain the specific information you want on the report. Rather than modifying the report and generating a new spool file that includes the required information, you can define substitute select keys.
When you burst reports that use substitute select keys, EBB uses the original and substitute select keys. The system uses substitute select keys as if they were on the report originally.
Use substitute select keys to burst and bind reports when:
Information on which you want to burst on is not in the report
Information between two reports relates, but is not identical, and you must match this to bind the reports together
Select keys, both the original and substitute, exist in any one file
Substitute select keys require a cross-reference table, between the original and substitute select keys, before EBB can burst a report. Any EBB version can refer to any table. You can reference multiple reports within multiple versions, that burst using the same original and substitute select key combinations, to the same cross reference table. To more easily distinguish one burst report from another, print the substitute select key on the reports.
This section includes the following tasks:
Define substitute select keys
Generate the cross-reference index
Update the cross-reference table
The following are examples of how you can use substitute select keys to bind reports. Both examples use the same cross reference table.
In this example, EBB binds reports based on criterion that is not in the spool file.
A company organizes business units into divisions, with multiple business units in each division. A report runs by business unit each month using fifteen different DREAM Writer versions. Each DREAM Writer version generates a report for a specific division. The business unit number prints on the report, but the division code does not. EBB distributes the reports to the managers of each division.
The substitute select key option allows you to run the report once, selecting all fifteen divisions. Then EBB bursts the report by division and routes the reports to the appropriate division managers.
To accomplish this, a cross reference table must exist between the business unit number and the division code. The division code is the substitute select key. The substitute select key links the cross reference table to the EBB version.
In this example, two reports are bound. The data the system uses is not on one of the reports.
Report 1 contains all expenses in each business unit. Report 2 contains sales in each division. The division code is not on Report 1, but the company wants to distribute both reports to the division managers.
The substitute select key option allows you to bind two reports, even when the information the system needs for binding is not on both reports. To enable EBB to burst the sales and expenses reports by division, and route to the appropriate division managers, you must add a substitute select key for the division code to Report 1. The cross reference table provides the link between the business unit (the original select key) and the division code (the substitute select key). The division code is defined in Report 2 and requires only the setup of the division code as the select key on the report.