|
|
The features on this page require a GENESIS64 Advanced license and are not available with GENESIS64 Basic SCADA . |
|
|
The features on this page require a GENESIS64 Advanced license and are not available with GENESIS64 Basic SCADA . |
With the evolution of the AnalytiX-BI SQL language, some of the features from the previous version are being deprecated and kept for backwards-compatibility reasons only. For this reason, AnalytiX-BI introduces the concept of Compatibility Level for Data Models, which determines how some of the features of the SQL language work.
Currently, Data Models belonging to a configuration that has been upgraded from a previous version (prior to 10.97.1) will be set at compatibility level 0x109700 and function in backwards-compatibility mode. Data Models created in the current version will be set at compatibility level 0x109710 and will disable the backwards-compatible features.
Note: The Data Model compatibility level is currently not displayed in the UI, so it is not possible to change the compatibility level value assigned to a Data Model.
The differences between backwards-compatibility and current mode are the following:
Aggregated columns without an explicit alias will produce a different auto-generated output column name when running in current mode. See Automatically generated aliases for more information.
Expressions written with the Expression Engine syntax as string literals will be parsed and executed only when running in backwards-compatibility mode. See Using SELECT with calculations and scalar functions for more information.