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 (8)

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

  2. Did you see the post at blogs.msdn.com

  3. Anthony Martin says:

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

  4. MSDNArchive says:

    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.

  5. Neeti says:

    The attached link is not working. Please help.

  6. GN says:

    Link is not working. Is there any other location where i can find this sample database.

  7. Paulette says:

    Is there an updated link available?

  8. Ava says:

    the link not working is there any other location for download this database?