Reading and writing data on Analytical Workspace

Reading conditions

The Quick Data Loader’s behaviour when extracting data from Analytical Workspace depends on the following conditions:

• type of source dataset partitioning
• presence of the entity dimension column in the source dataset
• source type
• type of Quick Data Loader execution (for single node or single entity).

The general reading conditions and the relative data extraction policies are shown below.

Dataset partitioning	Reading layer	Specified dimensions	Data extraction policy
None	Reporting layer or calculation layer	Any dimension present on the layer, or none	The data is extracted from the single pre-existing partition.
By business cycle	Reporting layer	The data is extracted from the single pre-existing partition by process, scenario and period.
By business cycle	Calculation layer	Entity dimension not specified	The data is extracted from the single pre-existing partition by process, scenario and period.

The reading conditions when the extraction is initiated by an entity node are shown below.

Dataset partitioning	Reading layer	Specified dimensions	Data extraction policy
By business cycle	Calculation layer	Specified entity dimension	The data is extracted from the single pre-existing partition by process, scenario, period and selected entity node.
By business cycle and entity	Reporting layer or calculation layer	Any dimension present on the layer, or none	The data is extracted from all pre-existing partitions by process, scenario, period and entities belonging to the node.

The reading conditions when the extraction is initiated by an entity are shown below.

Dataset partitioning	Reading layer	Specified dimensions	Data extraction policy
By business cycle	Calculation layer	Specified entity dimension	The data is extracted from the single pre-existing partition by process, scenario, period and selected entity.
By business cycle and entity	Reporting layer or calculation layer	Any dimension present on the layer, or none	The data is extracted from the single pre-existing partition by process, scenario, period and entity.

Writing on Analytical Workspace

The Quick Data Loader’s behaviour when inputting data on Analytical Workspace depends on the following conditions:

• type of target dataset partitioning
• presence of the column related to the entity dimension in the target dataset
• type of selected target on which to load the data
• type of Quick Data Loader execution (single node or single entity)
• the Entities that were read in the extraction step
• the Deletion Policy defined for the Quick Data Loader
• the activation of the option on the entity dimension

The writing contexts and relative data loading policies are shown below.

Dataset partitioning	Loading layer	Specified dimensions	Data loading policy
None	Reporting layer or calculation layer	Any dimension present on the layer, or none	The data is loaded onto the single existing or created partition.
By business cycle	Reporting layer	Any dimension present on the layer, or none	The data is loaded onto the single existing or created partition by process, scenario and period.

The reading conditions when the loading is initiated by an entity node are shown below.

Dataset partitioning	Loading layer	Specified dimensions	Data loading policy
By business cycle	Calculation layer	Specified entity column	The data is loaded onto the single existing or created partition by process, scenario, period and the selected entity node.
By business cycle and entity	Reporting layer or calculation layer	Any dimension present on the layer, or none	The data is loaded separately on all existing or created partitions related to the process, scenario, period and entities belonging to the node.

The reading conditions when the loading is initiated by an entity.

Dataset partitioning	Loading layer	Specified dimensions	Data loading policy
By business cycle	Calculation layer	Specified entity dimension	The data is loaded onto the single existing or created partition by process, scenario, period and selected entity.
By business cycle and entity	Reporting or calculation layer	Any dimension present on the layer, or none	The data is loaded onto the single existing or created partition by process, scenario, period and entity.