CubeInstanceStorageOptions

Description

The CubeInstanceStorageOptions enumeration contains modes of saving data to a cube.

It is used by the following method:

ICubeInstanceDestination.CreateStorage.

Available Values

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.
4096	NanAsNull. All data is saved. Replace all non-numeric values by empty records.
8192	Attachments. Attachments storage mode for standard cube.

Comments

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.