Post reply

Creating a Solution File from an Existing SSAS Cube on the Server

  • September 11, 2009 at 10:01 am

    #210647

    We have an internal cube we've developed where, over time, the solution file has gone out of date with the production cube. Updates have been made to the production cube directly from BIDS as opposed to being made to the off line solution, then deployed.

    Is there a way to create a current solution file from the production cube? If you open the cube on the production server from BIDS, it asks if you want to create a solution file, but that only creates the file, it does not populate the entire project file with all the elements (dimensions, cubes etc) of the cube.

    Thanks,

    Dwight

  • September 11, 2009 at 12:37 pm

    #1052500

    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.

  • September 11, 2009 at 2:57 pm

    #1052572

    Wow. I really missed that one. Thanks VERY much - you helped me solve a major issue.

  • February 4, 2014 at 6:20 am

    #1685826

    Thanks a lot, I missed this thing, from last 4 months i'm connecting to DB directly to process the cube.

    Thanks,

    Nagaraju

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply