Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Deleting a Data Source in Solution Explorer (Analysis Services)

Deleting a data source is permanent. You cannot restore a deleted data source to a Microsoft SQL Server Analysis Services database or project. In Analysis Services, data sources provide the basis on which data source views are constructed, and data source views are in turn used to define dimensions, cubes, and mining structures in an Analysis Services project or database. Therefore, deleting a data source may invalidate other Analysis Services objects in an Analysis Services project.

Important noteImportant

Data sources on which other objects depend 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 before deleting the data source.

For more information about how to delete a data source object from a project, see How to: Delete a Data Source in Solution Explorer (Analysis Services).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.