Page Comparison

In the Transfer FAS 161 Average Volume Data - Batch panel, you can preprocess report data used by the FAS 161 Average Volume report. This global process populates the FAS161_AVG_VOL table to improve report performancein the ESTAR database, Use of the preprocess enables allows the FAS 161 Average Volume report to only perform calculations, such as the aggregate and average calculations, by using . Because the report can use the data from in the FAS161_AVG_VOL table. The FAS 161 Average Volume report returns a volume of derivative activity across a user-provided date range, namely daily, monthly, quarterly, and yearly or any user-defined date range as allowed. , it does not need to create temporary tables to retrieve data needed for its calculations. This improves the report performance 

You can run the preprocess manually using the Transfer FAS 161 Average Volume Data - Batch panel, or and can schedule the preprocess to run automatically on a regular basis. The first time you use the preprocess, the initial process can take some time. Running the preprocess periodically enhances the performance of  . To populate the FAS161_AVG_VOL table, you run an initial preprocess where you input the initial begin date and current date, thereby retrieving all historical data. When you run the preprocess manually, the system deletes and inserts data in the FAS161_AVG_VOL table, clearing and repopulating the table, You can then schedule the preprocess periodically. In essence, you schedule the preprocess as if you were running the FAS 161 Average Volume report for one day.

To generate transfer FAS 161 Average Volume report data:

1. In Accounting Center, in the left navigation pane, click Processing & Exceptions > Global Processes > FAS 161 Average Volume > Transfer FAS 161 Average Volume Data - Batch.
   You see the Transfer FAS 161 Average Volume Data - Batch panel.
2. Complete the options on the Transfer FAS 161 Average Volume Data - Batch panel.
3. Click Submit.
   You see the status of the event loopbacks in the Loopbacks pane at the bottom of the panel. The system creates a result set for each entity/basis/asset specified. Each time you generate results manually, the system deletes the original results data. It stores only new data in the table and displays it for use in the FAS 161 Average Volume report.

...