Delete Data From Olap cube

[aswolff]

Hello,

I have a MS-OLAP Cube. I want to get rid of the data in it and start from scratch. So I deleted all my data from the all dimension tables and fact table. Then I try to perform "Incremental Update", "Refresh Data", and "Rebuild" and they all fail with:

<code>
Processing error [Source data contains no rows] 'Volumes^Activities'S' ; Time:4/1/2008 10:53:34 AM
</code>

Help?

 

[MDXer]

What Version? AS2K you can't process an empty cube I typically use a template view to build my cubes from and I can apply a where clause to build a single data element into each dimension and fact table.

If you are using SSAS 2005 you can do a process cube structure.

BTW there is a Analysis Services Forum located:
Microsoft SQL Server: Analysis Services (OLAP)

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck