How to Restore olap cube on SQL Server 2008 basic Edition.

• Sid-614372

  SSC Rookie

  Points: 32

  More actions

  February 2, 2009 at 3:32 pm

  #199427

  I have a backup olap file .abf created on SQL 2005.

  I want to restore this .abf file on my 2008 basic Edition I installed on my XP SP2 machine.

  Is there a way to restore this .abf file on 2008 Basic Edition?

  I can create olap cubes using BIDS available on this version.

  I have tried SSIS to import the cube but i get errors complaining about duplicated table names?

  Is it possible to restore backup cubes using the 2008 basic/Trial version.

  Thanks.