October 9, 2009 at 3:59 pm
I have Analysis Service databases installed and working. I am able to open these databases in Visual Studio and make needed changes but the problem is I don't have the actual VS solution. Is there a way I can back into creating the Analysis Services solution and its related files if all I have is the installed cubes and databases?
October 9, 2009 at 7:32 pm
There's two things you can do -
1. to answer your question, yes, simply go to New | Project and select the Import Analysis Services X.0 Database project type (where X is either 9 or SQL 2008).
2. Connect to the AS database (using File | Open | Analysis Services Database). You are now connected to the 'live' DB (and cube/dims etc) Any changes you make here, on clicking save (and confirming the push to the server) will result in a change to the published object/s. While not great for source control or change control in general, lot of people make changes this way.
HTH,
Steve.
October 12, 2009 at 9:44 am
Thanks Steve! Option 1 worked perfectly.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply