Delete Rows from a Prism Data Source

You can delete the rows in a Prism data source. When you delete the rows, the Prism data source is empty and becomes inactive.

You might want to delete the rows in a Prism data source if the rows contain incorrect data and you don’t want analysts creating reports using the bad data. You can then edit the dataset to correct the transformation logic and activate the Prism data source again. When you activate the Prism data source, Workday populates the empty, inactive Prism data source with the new data.

Any reports that use an inactive Prism data source will be broken until you activate the Prism data source.

The steps for deleting rows from a Prism data source is different depending on the Prism artifact that created the data source:

Table. When a table is enabled for analysis, you can delete the rows from the corresponding Prism data source by truncating the table. To activate the Prism data source again, run a data change task that inserts data into the table.
Dataset. Follow the steps below. To activate the Prism data source again, republish the dataset.

For more information on the other ways of deleting Prism Analytics data, see Concept: Deleting Prism Data.