Editing a Dataset
From the grid view, you can edit the contents of your embedded (private) or standalone (public) dataset. Clean, structure, enrich or transform your data to model them at your needs by using: For example, manage dimensions and measures, filter your data, resolve data quality issues, set hierarchical relationship, define transform in cells, rows or columns, geo enrich your data, etc.
Context
When you create a story and import data from a file or other data source, but not from an existing saved model or dataset, that data is saved as an embedded dataset (also called a private dataset) within the story, and this dataset doesn't appear in the Files list. For details, see About Adding Data to a Story.
With your dataset open in SAP Analytics Cloud, you make changes directly to the data in the grid. For example, you can:
- Modify the name of the (embedded) dataset: In
Dataset Overview, select the 
(Edit) icon to the right of the current dataset name.
In the displayed dialog, provide a new name under Dataset
Name, and then select OK. - Resolve warnings data quality in your dataset: Anomalies in your data could
result in omissions from your visualizations. Typically, these data quality
issues involve missing data, measures containing non-numeric characters, or
dimensions assigned a mismatched data type:
.
Issues are displayed as links within the impacted column entries. Select the
links to view more detailed information listed under
Validation in the 
Column Details panel. - Manage measures and dimensions: for example, delete or rename entities, add geo-enriched data, define level-based hiercharchies, change the data type, set up the default aggregation type for your measures, etc . For more information, see Managing Measures and Dimensions in Your Dataset.
- Define transforms in cells, rows or columns; for example, to filter or replace values, or concatenate or split columns. See Performing a Data transformation in Cells, rows or Columns.
- Generate new custom transforms with the Custom Expression Editor
:
Type in a custom expression directly or use keyboard shortcuts to build an
expression. The Custom Expression Help panel gives you a detailed description,
syntax, and examples for each of the available functions. For example, you can
add unique row numbers to each row of your dataset: Adding Unique Row Numbers to Each Row of Your Dataset - Reimport data in your dataset: Reimporting Data into a Dataset.