Home Forums SQL Server 2005 Business Intelligence Creating a Solution File from an Existing SSAS Cube on the Server RE: Creating a Solution File from an Existing SSAS Cube on the Server

  • Open up BIDS (VS) and instead of connecting to the SSAS DB/Cube, select New Projct. In the project type, select 'Import Analysis Services 9.0 Database' (in 2008 it replaces '9.0' with '2008'), run through the wizard which basically requires an AS server and DB, voila, you have a project based on the server copy.

    HTH,

    Steve.