Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating a Solution File from an Existing SSAS Cube on the Server Expand / Collapse
Author
Message
Posted Friday, September 11, 2009 10:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 1:30 PM
Points: 3, Visits: 28
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
Post #786526
Posted Friday, September 11, 2009 12:37 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Sunday, April 13, 2014 11:43 PM
Points: 1,781, Visits: 3,340
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.
Post #786640
Posted Friday, September 11, 2009 2:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 1:30 PM
Points: 3, Visits: 28
Wow. I really missed that one. Thanks VERY much - you helped me solve a major issue.
Post #786720
Posted Tuesday, February 04, 2014 6:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 11:19 PM
Points: 1, Visits: 6
Thanks a lot, I missed this thing, from last 4 months i'm connecting to DB directly to process the cube.


Thanks,
Nagaraju
Post #1537731
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse