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. TheAnonymous
January 03, 2008
Did you see the post at blogs.msdn.comAnonymous
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?