Newbie

Apr 19, 2009 at 3:02 PM
Hi

I am trying out AS stored procedures but didnt get anywhere yet. The thing blocking me is seeing code work in Visual Studio.

The material I am using is

*) the project in here
*) this link

http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!586.entry

and i want to end up doing this:

http://sqlblog.com/blogs/mosha/archive/2008/09/01/drillthrough-on-calculated-measures.aspx

Because that is usable on solution I am working on.

However I have trouble gettin even the project in here to work on my machine. When I open the source project in VS it says

"the source control provider associated with this solution could not be found. The projects will be treated as not under source
control. Do you want to permanently remove the source control bindings from the projects ?"

I say no to this but then when i try to rebuild it give me long error list. One of errors is this reference doesnt work.

"Warning 2 Could not resolve this reference. Could not locate the assembly "msmgdsrv". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. ASSP

Can someone help ?
Coordinator
Apr 20, 2009 at 10:09 PM
You can remove the source control if you are working on your own version of ASSP. These are only links back to the codeplex repository.

The references may be in a different place on your machine. If you open the references folder in the solution it should show you which ones can't be located. You can either add a reference path to the project properties to tell it where else to look for these references or you can remove the existing references and add new ones that point to the location on your machine. If you don't have a local instances of SSAS on your machine you may need to copy the msmgdsrv.dll file from your server.