Changing the Dimensionality of a Dataset – Fusion Data Mapper
Use cases:
- Adding or removing dimensions
- Creating a copy of a dataset with completely different dimensionality
The dimensionality of a dataset is defined by its DSD which, once created, cannot be changed without deleting all of the metadata mappings that use it.
To change the dimensionality of a dataset, the recommended procedure is to create a new dataset with the required dimensionality and copy the series and mapping rules from the old dataset to the new.
Two methods are available:
- Excel Export / Import
- Clone Dataset
Excel Export / Import Method
Changing the Dimensionality of a Dataset – Prerequisites
- The dataset to change exists.
- The SERIES_CODE dimensions in the old and new DSDs must share the same Codelist, or the Codelists must contain the same series codes that you want to map.
Changing the Dimensionality of a Dataset - Required Roles and Privileges
The user must be a member of the Agency that owns the SDMX Structure Set, or a member of a parent Agency if a hierarchical agency structure is in place.
Changing the Dimensionality of a Dataset – Procedure
Create a new dataset using the DSD describing the revised dimensionality. To keep the same SDMX Dataflow, specify the same Dataset ID, but with a new version number, e.g. 1.1 or 2.0. Export the complete set of series mappings into Excel from the old dataset. Modify the Excel to add or remove dimension columns in the Excel to match the DSD of the new dataset. If adding dimension columns, blank cells will result in the default values being used. Import the Excel into the new dataset.
Clone Dataset Method
Changing the Dimensionality of a Dataset – Prerequisites
- The dataset to change exists.
- The SERIES_CODE dimensions in the old and new DSDs must share the same Codelist, or the Codelists must contain the same series codes that you want to map.
Changing the Dimensionality of a Dataset - Required Roles and Privileges
The user must be a member of the Agency that owns the SDMX Structure Set, or a member of a parent Agency if a hierarchical agency structure is in place.
Changing the Dimensionality of a Dataset – Procedure
- Follow the procedure for cloning datasets explained in Clone a Dataset.
