Chapter 6 The ForestryValidationAnnualChanges module

The module ForestryValidationAnnualChanges pulls out records with significant abnormal high annual changes on production, imports and exports according to parameters set by the user.

Figure 6.1: Workflow of the ForestryValidationAnnualChanges module

6.1 Steps

The module applies simple check in the data. Basically it does the following.

6.1.1 Read in data

The module reads data from forestry_prod_trade_agg dataset and from the datatables listed in the figure 8.1.

6.1.2 Data filtering

After pulling the needed data, the module applies filters using the parameters chosen by the user accordingly. The module has two kinds of parameters:

• time range (start and end year of the process) - Start year and End year;
• quantity threshold (minimum quantity analysed) - Production Qty threshold.
• percentage change - Percentage Change.

6.1.3 Annual Change check

At this stage, there are only the target data as the time range and quantity threshold were applied. Therefore, the module verifies if within the remaining data there is any item with an percentage annual change beyond its limits.

6.1.4 Email the user

The final step of this module is to email the user with the output.

6.2 Running the module

1. Log in the SWS;

2. Click on New Query;

3. Select Forestry domain and forestry_prod_trade_agg dataset;

4. Select whatever geographicAreaM49, measuredElement, measuredItemForestry and timePointYears. After that, run the query;
   

   

   Figure 6.2: Steps 1 to 4

   
   

5. Select the ForestryValidationAnnualChanges module, choose the parameters (Start and End year ; Percentage change ; Production Qty threshold) and click on Run plugin;

Figure 6.3: Select the ForestryValidationAnnualChanges plugin and run it

6. Wait for a window message to appear in the session;

Figure 6.4: ForestryValidationAnnualChanges module ran successfully

7. Get your results sent by email.
   

   Figure 6.5: Email sent to the user with results