Total Cost Field Processor
Total Cost field processor is designed for summing up on meter all cost values generated by different tariffs.
For example, we have next cost fields calculated by Fixed and Running tariffs January 2020:
Fixed Cost, by EL Fixed Month Tariff tariff, Month, EL ProdType/EL Util = 1 Kr
Running Cost, by Running EL Tarif tariff, Month, EL ProdType/EL Util = 1300 Kr
The Total Cost filed processor will sum those values and create new fields for certain meter:
Total Running Cost, EL ProdType/EL Util = 1300 Kr
Total Fixed Cost, EL ProdType/EL Util = 1 Kr
Total Cost, EL ProdType/EL Util = 1301 Kr
After installation of KTC Server cost field processor is automatically created in Data Field Processors data source with name Total Cost Calculator and type Analyser Total Cost Calculator
The Total Cost Field Processor expects that all Cost fields generated by different tariffs for each meter as its input. You can read more about it in the Cost Field Processor section.
In order to modify field processor name or set user privilege you have to login into Clayster Management tool and open Data Field Processors data source, then select in data source Total Cost Calculator item and edit it. In a picture below you can see properties window, where all parameters and options should be set up.
Setup total cost calculation job
In Data Field Processors data source create a new Total Cost field processor or use existing one with name Total Cost Calculator
In Jobs data source create a new Field Sink Read Job which suppose to read data from ProcessedData_Month or Proxy field sink and process data using Total Cost Calculator field processor. For data storage in calculation job should be set ProcessedData_Month or Proxy field sink. Standard customer job sequence, which includes all cost jobs, could be generated from context menu for each customer in customer data source.
- On the Content tab make sure that option Subresults may be divide is NOT checked and Read nodes from bottom and up is checked, otherwise the results might not be correct.
- You should set filter by customer group node or appropriate summary node:
- Select instance of Total Cost Field Processor in Processors tab:
- In order to have better performance in Advanced Filter tab select "Include numeric values" only:
- Execute job
Open Clayster Management tool and Setup total cost calculation job. Follow next steps in order to precalculate input data to get total cost fields created by total cost field processor.
Calculate meter Cost fields (see Cost Field Processor section)
Execute job with show result option
Check if total costs calculated correctly
Total Cost field processor is a part of KTC Server in order to install it administrator needs
perform deployment of the zip package and configure it according to the hosting model.