SAP BW Reporting Agent has been discussed in the previous post and here is the continuation for that.
When you are determining the drill down characteristics in the settings for exception reporting, pay attention to the order in which the characteristics appear, and how many characteristics there are. The following example shows how the order in which the characteristics appear affects the process: In a query with an exception definition, two of the characteristics you specified were Calendar year/month and Country. The characteristic Calendar year/month has twelve values (for the twelve months of the last calendar year), and the characteristic Country has 85 values (because you have customers in 85 countries).
In the settings for exception reporting, you want to set both characteristics as drill down characteristics. Drag the characteristic Calendar year/month into the definition. Provided that every characteristic combination contains data, you get a maximum of twelve query views to choose from; one view with 85 countries for every month of the calendar year. If, on the other hand, you select the characteristic Country, you get a maximum of 85 views; one view with twelve months for every country. Note that the number of views multiplies as soon as you select more than two drill down characteristics. In addition to the drilldown views, you get one overview-view per characteristic.
Notification By E-Mail or SAP Office Mail
If you chose the mail option as the follow-up activity, the mail recipients that you specified are sent an e-mail automatically through the SAP Office system, or to their Internet address, notifying them of the exceptions that have occurred.
Deleting a Scheduled Packet
The exception log records which packets have been processed/are scheduled for processing in the background. You call the Exception Log in the Reporting Agent using the menu path All Packets - Exception Reporting - Exception Log. Information on the packets you created is displayed here, showing you whether your packets are active or not. If you want to cancel the processing for a packet that has been scheduled, delete the relevant processing data. To do this, click with the right mouse-button on the schedule data under the name of the packet and choose Delete.
Reporting Agent: Printing in the Background
The second function in the Reporting Agent enables you to process print requests in the background (batch printing). You can schedule a range of print requests specifically for printing in the background. You can use the batch-printing function to evaluate queries. The print layout in the Reporting Agent determines the reporting conditions for a query. You can create as many print settings as you like for a query. The settings are collected in packets, and scheduled for background processing. The result is a printed query showing a particular view of the InfoCube data, determined by the print layout. In the central box, drag the cursor over a query that you want to print in the background. Click with the right mouse-button, and choose New Setting.
Settings for Background Printing
When you give the print setting a name, and put a check in the checkbox for Print in background,two extra tabstrips appear. On the Print Settings tabstrip you make general settings to determe how the printed copy is displayed, for example, margins, the position of the currency and unit details, +/- signs, and results.
On the Print Layout tabstrip, you determine the drilldown for the query that you want to print. You determine how the printed query is displayed in much the same way as you do for an online analysis in the BEx Analyzer. You drag into the rows and columns the key figures and characteristics that you want to appear on the query printout. You also determine how characteristics are displayed on the cover sheet, the page header and footer, and the final page in this way. You have the option of defining texts for the cover sheet, page header, footer, and final page.
Displaying Key Figures and Characteristics
You have the option of specifying how the query elements defined in the print settings are displayed. To do this, drag the cursor over the required query element, and call up the context menu (right mouse-click). Choose Properties. Two tabstrips appear, on which you make display settings for the elements on the print-out, or for hierarchies. As soon as you have made all the batch printing settings, save your entries and activate the settings.
Batch Print Parameters
When you have saved and activated your print settings, follow the procedure described above to create a scheduling packet under Backgroung Printing, and assign the print-settings definition to this packet using the drag-and-drop function. Before you schedule the packet for processing, you must maintain the print parameters. Make sure that the Change mode is active (is displayed in the right-hand window). Drag the cursor over the packet you want to maintain, and choose Maintain Print Parameters from the context menu (right mouse click). Fill all the required entry fields with the relevant information on the input device, number of pages, spool control, and so on. Confirm your entries by clicking on the icon with the green check. You are now able to schedule the packet for processing.
Reporting Agent Structure
When you work with background processing, you can make several different settings for a query definition. These can be settings for exception reporting as well as for batch printing. You assign the settings to individual packets and schedule them.