D EBB Examples
This appendix provides examples with tasks to compile, collate, and distribute reports. You can use these examples before you begin working with Electronic Burst and Bind. This appendix includes these topics:
Choose Generate Demo Spool Files from the Electronic Burst and Bind menu (G98E). The Generate Demo Spool Files program provides three demonstration spool files:
-
DEMO_RPT1
-
DEMO_RPT2
-
DEMO_RPT3
The spool files are in RDY status.
You must move the spool files to the EBBSTART output queue.
D.1 Producing a Basic Report Version
The following example includes tasks you complete to setup a basic EBB version. The example produces a general ledger report, separated by account category and then routes each burst report to a different output queue.
In this example you use DEMO_RPT1. You can change the User Data Spool File Attribute to the name you use for the EBB version ID. In this example, DEMO1 is the attribute name in the spool file, DEMO_RPT1. Since the spool file attribute and name are satisfactory, you do not need to change either.
To produce the Basic Report Version, complete the following tasks:
-
To end the EBB monitor
-
To add a new version ID
-
To add the spool file to the version
-
To identify the burst area
-
To load select keys
-
To create a routing function
-
To assign routing functions
-
To start the EBB monitor
-
To check messages
-
To check the output files
From Electronic Burst and Bind (G98E), choose End EBB Monitor
Before you create an EBB version, ensure that the EBB monitor is not active.
-
After ending the EBB Monitor, on the Electronic Burst and Bind menu (G98E), choose Display EBB Message Queue.
The following message displays:
EBB monitor ended
Figure D-1 Display Messages (EBB Monitor Ended) screen
Description of "Figure D-1 Display Messages (EBB Monitor Ended) screen"
-
Exit (F3) to the Electronic Burst and Bind menu.
From Electronic Burst and Bind (G98E), choose Maintain EBB Versions
The EBB Setup File contains the default job and output queues for EBB. The EBB Setup File also stores other default information, such as the monitor delay time and the location of JD Edwards World source. This information displays on the Maintain EBB Versions screen. See Chapter 5, "Overview to Versions" for more information.
-
On Maintain EBB Versions, choose EBB Version - Set Up (F6).
-
On Add EBB Version ID, enter DEMO1 in the EBB Version ID field.
-
Enter EBB DEMO VERSION in the Version Description field.
-
Complete the following fields and click Enter:
-
`Error Outq
-
`Keep a Spool File
-
`Make a note of the version defaults. You can change them if necessary.
-
To add the spool file to the version
After you create a new version ID, the EBB Reports Selection screen should display. If Maintain EBB Version displays, enter 1 in the Option field next to DEMO1.
-
On EBB Reports Selection, choose Display Spool file for selection (F8).
Figure D-4 Spool File Selection (Add) screen
Description of "Figure D-4 Spool File Selection (Add) screen"
-
On Spool File Selection, enter EBBSTART in the following field:
-
"OUTQ
-
-
On Spool File Selection, enter 1 next to DEMO_RPT1 in the Option field.
Notice that 'Selected' displays on the far right next to the file.
Figure D-5 Spool File Selection (DEMO_RPT1) screen
Description of "Figure D-5 Spool File Selection (DEMO_RPT1) screen"
-
Exit (F3) to EBB Reports Selection.
The report name DEMO_RPT1 displays in the versions report list.
Figure D-6 EBB Reports Selection (Report Name Displayed) screen
Description of "Figure D-6 EBB Reports Selection (Report Name Displayed) screen"
After adding the spool file report to the version ID, you should be on the EBB Reports Selection screen. You are now ready to identify the burst area.
You must identify the area on the report (not actual data or data values) for which EBB will burst the report. In this example, you select the Account Category for the burst area. See Chapter 13, "Overview to Burst and Bind Criteria" for more information.
-
On EBB Reports Selection, enter 1 in the Option field next to the DEMO_RPT1.
Figure D-7 EBB Reports Selection (Identify Burst Area) screen
Description of "Figure D-7 EBB Reports Selection (Identify Burst Area) screen"
-
In the Burst Selection Setup area, enter 2 for Spool file Example.
-
On Spool File Selection, enter EBBSTART in the OUTQ field.
-
Enter 1 next to DEMO_PRT1 in the Option field.
The first page of the report displays.
Figure D-8 Electronic Burst & Bind (Identify Burst Area) screen
Description of "Figure D-8 Electronic Burst & Bind (Identify Burst Area) screen"
-
Move the cursor to the space immediately before the Account Category data area 00002006, and choose Begin Mark (F8).
The system highlights the data 00002006 and the remainder of the report.
-
Move the cursor to the space immediately after 00002006 and choose End Mark (F9).
The system highlights only the data 00002006.
-
Choose Add/Change (F10) to verify the burst area.
On the EBB Row and Column Maintenance window the area you chose on Select Key Maintenance should be in row 006, column 002, and have a length of 008. If your form does not reflect this, choose Delete Requested from the Function menu to clear the burst area. Return to the first page of the report and repeat the previous steps to mark the beginning and end of the burst area.
-
Exit (F3) to the Spool File Selection screen.
After identifying the burst area, you should be on Spool File Selection. You are now ready to load the select keys. This creates select keys for the EBB version. See Chapter 19, "Load Select Keys" for more information.
-
On Spool File Selection, enter 7 in the Option field next to DEMO_RPT1.
Figure D-9 Spool File Selection (Load Select Keys) screen
Description of "Figure D-9 Spool File Selection (Load Select Keys) screen"
-
When the job completes, the following message displays:
Preload Select Keys have completed. You can see New Select Keys in last column.
-
Exit (F3) until you return to the Electronic Burst and Bind menu.
After loading data in the burst area, you are now ready to create a routing function.
Create a new routing function naming it PRINT2. You will modify the initial PRINT function in this example.
See Section 22.2, "Creating a Routing Function from an Existing Function" for more information.
From Electronic Burst and Bind (G98E), choose Maintain EBB Functions
On Maintain EBB Functions the list of available routing functions displays.
-
On Maintain EBB Functions, enter 1 in the Option field next to the PRINT function.
The PRINT function parameters display on EBB - Maintain Function Description.
Figure D-10 EBB - Maintain Function Description screen
Description of "Figure D-10 EBB - Maintain Function Description screen"
-
Enter PRINT2 in the Function Name field.
Figure D-11 EBB - Maintain Function Description (PRINT 2) screen
Description of "Figure D-11 EBB - Maintain Function Description (PRINT 2) screen"
-
Exit (F3) to the Maintain EBB Function screen.
Notice that PRINT2 is now in the function list on Maintain EBB Functions.
Figure D-12 Maintain EBB Functions (PRINT 2 Displayed) screen
Description of "Figure D-12 Maintain EBB Functions (PRINT 2 Displayed) screen"
-
Exit (F3) to the Electronic Burst and Bind menu.
You are now ready to determine where to route each select key. You can add routing functions as necessary. See Chapter 24, "Assign Routing Functions to Select Keys" for more information.
From Electronic Burst and Bind (G98E), choose Maintain EBB Versions
-
On Maintain EBB Versions, enter 2 in the Option field next to DEMO1.
Select keys for the report display on the Select Key Maintenance screen.
-
Enter 1 in the Option field for the select key 00002006.
-
On Entity/Function Maintenance, choose Add Function for Entity (F6).
Information for the PRINT function displays on Entity/Function Parms Maintenance.
-
Click Enter.
-
Exit (F3) to Select Key Maintenance.
Notice an * displays next to the 00002006 select key, indicating that a routing function is attached to the select key.
-
On Select Key Maintenance, enter 1 in the Option field next to the 00002006 select key.
-
On Entity/Function Maintenance, choose Add New Function for Entity (F6).
Fields display blank on Entity/Function Parms Maintenance.
-
To display the additional routing functions, choose Retrieve Functions (F4).
-
On Function Selection, enter 4 in the Option field next to the PRINT2 function.
-
On Entity/Function Parms Maintenance, enter EBBFINAL or another output queue in the Parm 1 field to change the output queue.
-
Optionally, enter the number of copies in the Parm 2 field and click Enter.
-
Exit (F3).
The routing functions PRINT and PRINT2 display on Entity/Function Maintenance.
Figure D-13 Entity/Function Maintenance screen
Description of "Figure D-13 Entity/Function Maintenance screen"
-
Exit (F3) to the Select Key Maintenance screen.
You can assign a new routing function to another select key by choosing another select key and repeating the steps to assigning a routing function.
-
Exit (F3) to the Electronic Burst and Bind menu.
After assigning routing functions, you are now ready to start the monitor.
From Electronic Burst and Bind (G98E), choose Start EBB Monitor
-
After starting the EBB Monitor, on the Electronic Burst and Bind menu (G98E), choose Display EBB Message Queue.
The following message displays:
EBB monitor started
Figure D-14 Display Messages (EBB Monitor Started) screen
Description of "Figure D-14 Display Messages (EBB Monitor Started) screen"
-
Exit (F3) to the Electronic Burst and Bind menu.
From Electronic Burst and Bind (G98E), choose Display EBB Message Queue
Check messages periodically as the monitor processes the report, as well as the active jobs.
The Display Messages screen displays messages if problems arise while the monitor processes the reports. Because EBBSTART is the output queue for one of the burst reports, the monitor attempts to process the report. No EBB version exists for the report, and the monitor generates the following message:
No EBB Version found for spool file with userdata: P98E04
Disregard this message and Exit (F3) the Display Messages screen.
Check the EBBFINAL output queue for the burst, original, and process report, R98E04. View the process report, R98E04, to determine which spool files the monitor creates for the select keys, the spool file IDs, and output queues. The number of reports the monitor creates in the default queue - EBBFINAL, the error queue - EBBERRQ, and other output queues - EBBSTART display on the process report.
Separate reports exist for each select key, as well as the other two select keys for the additional routing functions. Print or view the reports in EBBFINAL and EBBSTART to examine the results of how the system bursts reports and creates banner pages. Also check any reports that might be in EBBERRQ, the error queue.
When the monitor returns to a delay status, EBB has finished processing your jobs and the reports are available in the EBBFINAL out queue. When EBB finishes processing, stop the monitor.
D.2 Producing an Advanced Report Version
The following example explains how to set up an advanced EBB version. In this example, you set up two monthly reports to burst and bind by manager. You will combine the Annual Revenue by Manager Report with the Profit Analysis by Region Report. The second report does not display the manager field. However, because each region reports to a specific manager, you build a cross-reference between the region and the manager codes. EBB then bursts both reports by manager and binds them to route them properly.
In this example you use DEMO_RPT2 and DEMO_RPT3. You must ensure the spool files are in the EBBSTART output queue.
To produce the Advanced Report Version, complete the following tasks:
-
To end the EBB monitor
-
To add a new version ID
-
To add the spool file to the version
-
To identify the burst area on DEMO_RPT2
-
To identify the burst area on DEMO_RPT3
-
To load data in the burst area
-
To create a routing function
-
To assign routing functions
-
To start the EBB monitor
-
To check messages
-
To check the output files
Before you create an EBB version, ensure that the EBB monitor is not active.
From Electronic Burst and Bind (G98E), choose End EBB Monitor
-
After ending the EBB Monitor, on the Electronic Burst and Bind menu (G98E), choose Display EBB Message Queue.
The following message displays:
EBB monitor ended
Figure D-15 Display Messages (EBB Monitor Ended) screen
Description of "Figure D-15 Display Messages (EBB Monitor Ended) screen"
-
Exit (F3) to the Electronic Burst and Bind menu.
The EBB Setup File contains the default job and output queues for EBB. The EBB Setup File also stores other default information, such as the monitor delay time and the location of JD Edwards World source. This information displays on the Maintain EBB Versions screen.
From Electronic Burst and Bind (G98E), choose Maintain EBB Versions
-
On Maintain EBB Versions, choose EBB Version - Set Up (F6).
Figure D-16 Maintain EBB Versions (Add New Version ID) screen
Description of "Figure D-16 Maintain EBB Versions (Add New Version ID) screen"
-
On Add EBB Version ID, enter DEMO2 in the EBB Version ID field.
-
Enter EBB DEMO VERSION 2 in the Version Description field.
-
Complete the following fields and click Enter:
-
`Error Outq
-
`Keep a Spool File
-
Figure D-17 Add EBB Version ID (DEMO2) screen
Description of "Figure D-17 Add EBB Version ID (DEMO2) screen"
-
To add the spool file to the version
After you create a new version ID, the EBB Reports Selection screen should display. If Maintain EBB Version displays, enter 1 in the Option field next to DEMO2.
-
On EBB Reports Selection, choose Display Spool file for selection (F8).
Figure D-18 EBB Reports Selection (Add Spool File) screen
Description of "Figure D-18 EBB Reports Selection (Add Spool File) screen"
-
On Spool File Selection, enter EBBSTART in the following field:
-
`On Spool File Selection, enter 1 next to DEMO_RPT2 and DEMO_RPT3 in the Option field.
Notice that 'Selected' displays on the far right next to the file.
Figure D-19 Spool File Selection (EBBSTART) screen
Description of "Figure D-19 Spool File Selection (EBBSTART) screen"
-
Exit (F3) to EBB Reports Selection.
The report names DEMO_RPT2 and DEMO_RPT3 display in the versions report list.
To identify the burst area on DEMO_RPT2
After adding the spool file report to the version ID, you should be on the EBB Reports Selection. See Chapter 13, "Overview to Burst and Bind Criteria" for more information.
-
On EBB Reports Selection, enter a 1 in the Option field for DEMO_RPT2.
-
In the Burst Selection Setup area, enter 2 for the Spool file Example.
-
On Spool File Selection, enter EBBSTART in the OUTQ field.
-
Enter 1 next to DEMO_PRT2 in the Option field.
The first page of the report displays.
-
Move the cursor to the space immediately before the Manager data a).
The system highlights the data JOE and the remainder of the report.
-
Move the cursor to the space immediately after JOE and choose End Mark (F9).
Figure D-20 Electronic Burst & Bind (Identify DEMO_RPT2) screen
Description of "Figure D-20 Electronic Burst & Bind (Identify DEMO_RPT2) screen"
-
Choose Add/Change (F10) to verify the burst area.
On the EBB Row and Column Maintenance window the area you chose on Select Key Maintenance should be in row 006, column 002, and have a length of 003. If your form does not reflect this, choose Delete Requested from the Function menu to clear the burst area. Return to the first page of the report and repeat the previous steps to mark the beginning and end of the burst area.
-
Exit (F3) to the EBB Reports Selection screen.
To identify the burst area on DEMO_RPT3
After adding the spool file report to the version ID, you should be on the EBB Reports Selection. See Chapter 13, "Overview to Burst and Bind Criteria" for more information.
-
On EBB Reports Selection, enter a 1 in the Option field for DEMO_RPT3.
-
In the Burst Selection Setup area, enter 2 for the Spool file Example.
-
On Spool File Selection, enter EBBSTART in the OUTQ field.
-
Enter 1 next to DEMO_RPT3 in the Option field.
The first page of the report displays.
-
Move the cursor to the space immediately before the Region data area C, and choose Begin Mark (F8).
The system highlights the data C and the remainder of the report.
-
Move the cursor to the space immediately after C (to allow for the field to be 3 digits long), and choose End Mark (F9).
Figure D-21 Electronic Burst & Bind (Identify DEMO_RPT3) screen
Description of "Figure D-21 Electronic Burst & Bind (Identify DEMO_RPT3) screen"
-
Choose Add/Change (F10) to verify the burst area.
On the EBB Row and Column Maintenance window the area you chose on Select Key Maintenance should be in row 006, column 004, and have a length of 003. If your form does not reflect this, choose Delete Requested from the Function menu to clear the burst area. Return to the first page of the report and repeat the previous steps to mark the beginning and end of the burst area.
-
Exit (F3) until you return to the Maintain EBB Versions screen.
To load data in the burst area
You are now ready to load the data in the burst area for only the DEMO_RPT2. This creates select keys for the EBB version.
You will define a substitute select key for DEMO_RPT3 and therefore, you do not load select keys.
-
On Maintain EBB Versions, enter 5 in the Option field next to DEMO2.
-
On Spool File Selection, enter EBBSTART in the OUTQ.
Both DEMO_RPT2 and DEMO_RPT3 display.
-
Enter 7 in the Option field next to DEMO_RPT2.
Figure D-22 Spool File Selection (Load Data) screen
Description of "Figure D-22 Spool File Selection (Load Data) screen"
-
When the job completes, the following message displays:
Preload Select Keys have completed. You can see New Select keys in the last column.
-
Exit (F3) until you return to the Electronic Burst and Bind menu.
D.2.1 What You Should Know About
| Topic | Description |
|---|---|
| Substitute Select Key Cross-Reference in DREAM Writer | The installation package includes the F98E08 file and it contains the cross-reference table DEMO for use in this example. See Chapter 29, "Generate the Cross-Reference Index" for more information. |
To define a substitute select key
You use the Manager data area to burst DEMO_RPT2 and DEMO_RPT3. However, Manager is only in the DEMO_RPT2. To burst DEMO_RPT3 on Manager, you must define a substitute select key using Region. You chose Region as the data area in DEMO_RPT3 and it is the original select key in the cross-reference.
From Electronic Burst and Bind (G98E), choose Maintain EBB Versions
-
On Maintain EBB Versions, enter 1 in the Option field next to the DEMO2 version.
-
On EBB Reports Selection, enter 2 in the Option field for DEMO-RPT3.
-
On Substitute Key Maintenance, enter N in the Rebuild Cross-Reference field.
-
Enter DEMO in the Table Number field.
-
Enter N in the Print Substitute Select Key field and click Enter.
Figure D-23 Substitute Key Maintenance screen
Description of "Figure D-23 Substitute Key Maintenance screen"
EBB Reports Selection displays.
-
Exit (F3) until you return to Maintain EBB Versions.
-
On Maintain EBB Versions, enter 1 in the Option field for DEMO2.
On EBB Reports Selection, the notation SK indicates that a substitute select key exists for this report.
Figure D-24 EBB Reports Selection (Notation SK) screen
Description of "Figure D-24 EBB Reports Selection (Notation SK) screen"
-
Exit (F3) until you return to the Electronic Burst and Bind menu.
Create a new routing function, XXXX, for this example. Available routing functions display on Maintain EBB Functions.
From Electronic Burst and Bind (G98E), choose Maintain EBB Functions
-
On Maintain EBB Functions, choose Create Function (F6).
Figure D-25 Maintain EBB Functions (Create Function) screen
Description of "Figure D-25 Maintain EBB Functions (Create Function) screen"
The fields display blank on EBB Maintain Function Description.
Figure D-26 EBB - Maintain Function Description (Blank) screen
Description of "Figure D-26 EBB - Maintain Function Description (Blank) screen"
-
Complete the following fields:
-
`Description
-
`Parameters
-
-
Enter the following in the Command String field:
chgsplfa file (&) job(&/&/&) splnbr(&) formtype(xxx)
-
Enter the following in the Default Parm 1 through 5 fields respectively:
-
*SPLNAM
-
*JOBJUM
-
*USER
-
*JOBNAM
-
XXXX (where XXXX is the form type name)
Figure D-27 EBB - Maintain Function Description (Default Parameters) screen
Description of "Figure D-27 EBB - Maintain Function Description (Default Parameters) screen"
-
-
Click Add.
-
Exit (F3) to Maintain EBB Functions.
Notice that XXXX is now in the function list.
Figure D-28 Maintain EBB Functions (XXXX) screen
Description of "Figure D-28 Maintain EBB Functions (XXXX) screen"
-
Exit (F3) until you return to the Electronic Burst and Bind menu.
You now determine where to route each select key.
From Electronic Burst and Bind (G98E), choose Maintain EBB Versions
-
On Maintain EBB Versions, enter 2 in the Option field next to DEMO2.
Select keys for the report display on the Select Key Maintenance screen.
Figure D-29 Select Key Maintenance (Assign Routing) screen
Description of "Figure D-29 Select Key Maintenance (Assign Routing) screen"
-
Enter 1 in the Option field for the Ann select key.
Figure D-30 Entity/Function Maintenance (Ann) screen
Description of "Figure D-30 Entity/Function Maintenance (Ann) screen"
-
On Entity/Function Maintenance, choose Add New Function for Entity (F6).
Information for the PRINT function displays on Entity/Function Parms Maintenance.
Figure D-31 Entity/Maintenance Parameters Maintenance (Add New) screen
Description of "Figure D-31 Entity/Maintenance Parameters Maintenance (Add New) screen"
-
Click Enter.
-
Exit (F3) to Select Key Maintenance.
An * displays next to the Ann select key, indicating that a routing function is attached to the select key.
Figure D-32 Select Key Maintenance (* Displayed) screen
Description of "Figure D-32 Select Key Maintenance (* Displayed) screen"
-
On Select Key Maintenance, enter 1 next to the Ann select key.
-
On Entity/Function Maintenance, choose Add New Function for Entity (F6).
Fields display blank on Entity/Function Parms Maintenance.
-
To display the additional routing functions, choose Retrieve Functions (F4).
Figure D-33 Function Selection (Retrieve Functions) screen
Description of "Figure D-33 Function Selection (Retrieve Functions) screen"
-
On Function Selection, enter 4 in the Option field next to the XXXX function.
Figure D-34 Entity/Function Parameters Maintenance (XXXX Function) screen
Description of "Figure D-34 Entity/Function Parameters Maintenance (XXXX Function) screen"
-
On Entity/Function Parms Maintenance, click Enter.
-
Exit (F3).
The routing functions PRINT and XXX display on Entity/Function Maintenance.
Figure D-35 Entity/Function Maintenance (PRINT and XXX Displayed) screen
Description of "Figure D-35 Entity/Function Maintenance (PRINT and XXX Displayed) screen"
-
Exit (F3) to Select Key Maintenance.
Figure D-36 Select Key Maintenance (Exit) screen
Description of "Figure D-36 Select Key Maintenance (Exit) screen"
-
Exit (F3) to the Electronic Burst and Bind menu.
After assigning routing functions, you are now ready to start the monitor.
From Electronic Burst and Bind (G98E), choose Start EBB Monitor
-
After starting the EBB Monitor, on the Electronic Burst and Bind menu (G98E), choose Display EBB Message Queue.
The following message displays:
EBB monitor started
Figure D-37 Display Messages (EBB Monitor Started) screen
Description of "Figure D-37 Display Messages (EBB Monitor Started) screen"
-
Exit (F3) to the Electronic Burst and Bind menu.
From Electronic Burst and Bind (G98E), choose Display EBB Message Queue
Check messages periodically as the monitor processes the report, as well as the active jobs. The Display Messages screen displays messages if problems arise while the monitor processes the reports. Because EBBSTART is the output queue for one of the burst reports, the monitor attempts to process the report. No EBB version exists for the report, and the monitor generates the following message:
No EBB Version found for spool file with userdata: P98E04
Disregard this message and Exit (F3) the Display Messages screen.
Check the EBBFINAL output queue for the burst, original, and process report, R98E04. View the process report, R98E04, to see which spool files the monitor creates for the select keys, the spool file IDs, and output queues. The number of reports the monitor creates in the default queue - EBBFINAL, the error queue - EBBERRQ, and other output queues - EBBSTART display on the process report.
Separate reports exist for each select key, as well as the other two select keys for the additional routing functions. Print or view the reports in EBBFINAL and EBBSTART to see how the system bursts reports and creates banner pages. Also check any reports that might be in EBBERRQ the error queue.
When the monitor returns to a delay status, EBB has finished processing your jobs and the reports are available in the EBBFINAL out queue. When EBB finishes processing, stop the monitor.