Managing Measures and Dimensions in Your Dataset

Open your dataset and update measures and dimensions using a large range of tools.

For every entity listed in Dataset Overview, select the icon to display a list of actions. For example:

Currently you can perform the following on both measures and dimensions:
  • Change a dimension to a measure, or a measure to dimension.
  • Delete an entity from the embedded dataset. The deletion will be instantaneous.
    Note
    The underlying column will not be deleted from the dataset, but consumption workflows will no longer consider it as part of the dataset.
  • Rename an entity; the entity name field becomes editable.
  • Set up a default aggregration type. For more information, see Setting up Default Aggregation Type for Measures in Datasets
  • Associate another column to a dimension column to serve as the dimension member description. Select your dimension, and in the Column Details panel, choose a column from the list under Description.
  • Geo-enriched your data with coordinates or by areas. If your dataset contains geographical data, you can:
    • Enrich a specific dimension with coordinates or area data.
    • Use columns containing geographic data to create a location dimension.
    For more information see Creating a Dataset with Geo-Enriched Data.
  • Create your own defined hierarchies using the available dimensions in Dataset Overview. For detailed information on creating hierarchies seeEditing a Dataset.
  • Change the data type: Although the data type for each column is inferred during the initial import, the assigned data type can be modified. Select the icon to view Details