How do you delete/empty/clear an SQL Analysis Services Cube?

Question

Ok, this is a noobie question, can't seem to find the answer in google.

As we know, the SSAS cube is stored in "C:\Program Files (x86)\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data"

How do you empty an SQL Server Analysis Services Cube? I do not want to delete the entire cube, I just want to delete data in it.

Thanks

Answer 1

In order to delete all data of a cube, you unprocess it. The easiest way to do that is as follows:

• Either in Management Studio right-click the Analysis Services database, or in BIDS, right-click the project.
• Then select "Process",
• in the dialog that appears, change the selection from "Process Full" to "Unprocess",
• and finally, click OK.