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)

Published 03 January 08 07:15 by alysonp

Comments

# Noticias externas said on January 3, 2008 2:18 PM:

Updated file PDW Backup Cube Included in the Monitoring Server sample data is a cube called PDW. The

# Windows Vista News said on January 3, 2008 6:00 PM:

Did you see the post at blogs.msdn.com

# Anthony Martin said on February 25, 2008 10:52 AM:

The link to the updated PDW.abf file is not working.  Please help.

# alysonp said on February 25, 2008 11:46 AM:

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 comments are disabled

Search

This Blog

Microsoft BI Sites

Syndication

Page view tracker