The CubeInstanceStorageOptions enumeration contains modes of saving data to a cube.
It is used by the following method:
| Value | Brief description |
| 0 | None. All data is saved. Existing records are overwritten independently of new value. |
| 256 | NoCheckDuplicates. Check for duplicates is not executed. There should be an empty data consumer. If there is an existing record, exception is thrown. This mode boosts data saving by reducing the number of queries to database server. |
| 512 | NoInsertNull. All data is saved. Empty records are not saved and not overwritten. |
| 1024 | InsertNulls. All data is saved. Empty records are saved and overwritten. |
| 2048 | UseTempTables. Temporary tables are used. First of all, all data is inserted into a temporary table, then missing data in the main table is checked and transferred in the DBMS server. NOTE. To use temporary tables, the table that stores cube data must be built on unique indexes. |
For time series database from the CubeInstanceStorageOptions enumeration only the NoInsertNull value is applicable. It is taken into account only for the Value attribute (VL) and it is not taken into account for the rest attributes of observation level.
See also: