Chapter 7 The ForestryValidationNegativeConsump module

The module ForestryValidationNegativeConsump is part of the validation procedure before dissemination. As per its name, it carries data validation on the negative consumption, if any. It is up to the user decides the parameters to be used in this phase.

Figure 7.1: Workflow of the ForestryValidationNegativeConsump module

7.1 Steps

The module can be basically split into four parts as below.

7.1.1 Read in data

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

7.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;

• negative consumption threshold - Negative consumption threshold. For instance, in this case if the user chooses -1000, the module will filter the time series that contain at least one data point with a Consumption <= -1000. For the sake of clarification, Consumption is definied as below:

  • Consumption = Production + Imports - Exports

7.1.3 Negative consumption check

At this stage, the module performs the Negative Consumption check over the data by using the parameter chosen by the user.

7.1.4 Email the user

The final step of this module is to email the user with one .csv file - negative consumption report.

7.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 7.2: Steps 1 to 4

   
   

5. Select the ForestryValidationNegativeConsump module, choose the parameters (Start and End year ; Negative Consumption threshold) and click on Run plugin;

Figure 7.3: Select the ForestryValidationNegativeConsump plugin and run it

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

Figure 7.4: ForestryValidationNegativeConsump module ran successfully

7. Get your results sent by email.
   

   Figure 7.5: Email sent to the user with results