Analyzing the impact of an improved feature on Data Aggregation
To analyze the impact of the
improved feature for the new Country and City fields, a parameter is available in which the usage of a specific field type in
Data Aggregation is investigated. Planon will scan throughout the
Data Aggregation configuration to find out where the field is used. The outcome is stored in the configured logging.
Although the trigger to develop the parameter is to enable customers to search for the old Country and City fields, the parameter is more flexible and can be used for other field types as well.
The parameter is called Check.On.Fieldtype and is applicable for both ReportSX and CalculateSX. With this parameter a comma-separated list of field types (system names) can be given.
ReportSX
For ReportSX it can be specified by adding a line in the Properties field of the linked Data Aggregation Properties BO as shown below:
When this parameter is given, the fields are not populated as usual, but the configuration is scanned on the use of the specified field types. In the regular logging output a list is given of the fields of the specified types that are used in the configuration. In case the old Country and/or City field type is specified, the SQL statements are also scanned if they use these kind of fields.
An example of the possible output is shown below:
CalculateSX
The same goes for CalculateSX: it can be specified by adding a line in the Properties field of the linked Data Aggregation Properties BO as shown below:
When this parameter is given, the fields are not populated as usual, but the configuration is scanned on the use of the specified field types. In the regular logging output a list is given of the fields of the specified types that are used in the configuration. In case The old Country and/or City field type is specified, the SQL statements are also scanned if they use these kind of fields.
An example of the possible output is shown below: