Error Restoring PDW sample data cube in 2008

  • Article

Updated file PDW Backup Cube

 

Included in the Monitoring Server sample data is a cube called PDW. The Monitoring Server Sample install will provide you with the PDW.abf file that should be restored to SQL Server Analysis Services 2005. However, there was a Current Week calculated member included in that cube that resolves to a time period in 2008 and this cube does not contain 2008 data. Thus, an error results when trying to restore this cube. The error will read as follows:

The level '[1-08]' object was not found in the cube when the string, [Time].[Week].[1-08], was parsed. (Microsoft.AnalysisServices)

The file attached to this blog post removes that calculated member from the cube and will enable you to restore this cube.

Sorry for the inconvenience this is causing.

Alyson Powell Erwin (alysonp@microsoft.com)