Deleting a Data Source View (Analysis Services)
Deleting a data source view is permanent. You cannot restore a deleted data source view to a Microsoft SQL Server Analysis Services project or database. In an Analysis Services project, deleting a data source view may invalidate other Analysis Services objects in the Analysis Services project.
Data source views that other objects depend on cannot be deleted from an Analysis Services database opened by Business Intelligence Development Studio in online mode. You must delete all objects in the Analysis Services database that depend on that data source view before deleting the data source view.
For more information about how to delete a data source view, see How to: Delete a Data Source View in Solution Explorer (Analysis Services).