MicroStrategy ONE
Edit Datasets
You can edit data that you have imported and saved as a dataset by adding new columns, renaming columns, changing the data type, etc. If you import data from a database using a custom database query, you can edit the query, then import and save a different set of results.
When you edit your saved data, the existing data is overwritten with the new data. If you want to add new data to your existing data, or replace existing data, you can republish a dataset.
-
Open a dashboard
- In the Datasets panel, click More to the right of the dataset you want to edit and choose Edit Dataset. The Preview Dialog opens.
- You can define each data column, such as specifying whether it is an attribute or a metric or assign it a geo role. You can refine your data to improve its quality. See Preview Data and Specify Import Options for more information.