Dataset settings window

Application database > Analytical Workspaces tile > click the workspace tile > (dataset tile) > Settings

Purpose of window

This window allows you to manage properties or delete a dataset.

Fields in window

Element	Description
Code	Dataset code. By default, the system uses a 6-character alphanumeric code. Cannot be edited once created. The code is unique among the physical and virtual Datasets belonging to the same Workspace.
Description	Description of the dataset in all enabled system languages.
Data Entry and Reporting properties
User data only	When selected, every authorised user can only access their own records via the reporting engine (whether in navigation or data entry mode). The system identifies the relevance of the records using the Userupd (current user code) field which is automatically defined in the dataset by the system when the user creates or edits a record.
Disable user right (read-only) check	When selected, it disables the read-only checks on dimensions when the form is opened and saved.
Disable process consistency checks	When selected, it disables the consistency with process checks when the form is opened and saved. Data is not consistent with the process when, in relation to a process dimension, it refers to an element that does not belong to the process. Note: when consistency checks are disabled, submission checks are also automatically disabled.
Disable submission checks	When selected, this disables submission checks when the form is opened and saved. Note: submission checks are automatically disabled when consistency checks are disabled.
Disable scenario/period locking checks	When selected, this disables scenario/period locking checks when the form is opened and saved.
Data update methods	This allows you to choose how data is saved after being changed: - Create new record (default) - Updates the existing record
Partitioning policy	Defines the policy for creating the physical tables (partitions) on which the dataset data will be saved. - By business cycle (default): if the process in use is a submission by scenario/period process, one partition is created for every scenario/period pair. If the process is a single submission process, one partition is created for all scenarios/periods in the process, but they are different for each process. - By business cycle & : applies the policy by business cycle and creates a specific partition for every entity. - None: all dataset data are saved in a single partition.
DTP properties
Reference dataset	Selects the reference dataset. - Dataset - Reference dataset - Reference dataset - Deploy - Reference dataset - Advanced settings - Reference dataset - Existence Once the Dataset has been created, its type cannot be changed. For more details on dataset types, see Reference dataset.

Buttons in the window

Application database > Analytical Workspaces tile > click the workspace tile > (dataset tile) > Settings

Element	Description
	Deletes the dataset. IMPORTANT: to delete a dataset, it must be offline and not in use in any virtual dataset or DTP. Once a dataset has been deleted, it will no longer be possible to recover any of the related data or settings. Any forms with references to the workspace will be invalid and must be updated manually.