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

Delete a Data Source View (Analysis Services)

If you are no longer using a data source view (DSV) in an OLAP project, you can delete it from the project in SQL Server Data Tools (SSDT).

Deleting a DSV is permanent. You cannot restore a deleted DSV to a Analysis Services project or database.

DSVs that other objects depend on cannot be deleted from an Analysis Services database opened by SQL Server Data Tools (SSDT) in online mode. To delete a DSV from a project that is connected o a database running on a server, you must first delete all objects in the Analysis Services database that depend on that DSV before deleting the DSV itself.

Deleting a DSV will invalidate other Analysis Services objects that depend on it, so before you delete the DSV, you will see the list of objects that will become invalid once the DSV is removed. Review this list carefully to be sure that it does not include objects you still expect to use.

Delete Objects dialog box
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.