Partilhar via


Error Restoring PDW sample data cube in 2008

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)

Comments

  • Anonymous
    January 03, 2008
    Updated file PDW Backup Cube Included in the Monitoring Server sample data is a cube called PDW. The

  • Anonymous
    January 03, 2008
    Did you see the post at blogs.msdn.com

  • Anonymous
    February 25, 2008
    The link to the updated PDW.abf file is not working.  Please help.

  • Anonymous
    February 25, 2008
    Please try it again later or send me an email so that I can email it to you (alysonp@microsoft.com). The blog site has been having a mountain of troubles for the last week or so.

  • Anonymous
    November 27, 2012
    The attached link is not working. Please help.

  • Anonymous
    April 02, 2013
    Link is not working. Is there any other location where i can find this sample database.

  • Anonymous
    September 05, 2013
    Is there an updated link available?

  • Anonymous
    May 10, 2014
    the link not working is there any other location for download this database?