Deployment Questions and Issues

Coordinator
Apr 10, 2008 at 8:53 PM
All feedback are welcome on how to enhance this solution starter!
Coordinator
May 8, 2008 at 9:42 PM
Edited May 12, 2008 at 7:03 PM
A problem was found when using the setup program on a 64 bits environments.
A updated version of the setup program hqs been posted v1.1.
As a workaround download the source code, and rebuild all the project. The setup project should include all files and not only the event handler DLL.
Steven
Nov 7, 2008 at 5:48 PM
Any idea if this solution will work with Project Server 2003 and AS2005?  I'm guessing no, due to the events that trigger the solution.  If not, is there a similar workaround available in the MSPS 2003/AS2005 environment, short of having a timed job recreate the roles after the cube build finishes?
Coordinator
Feb 24, 2009 at 2:22 PM
No this solution cannot be used with project server 2003, because there are not out of the box event handler. The workaround I use is to implement a breakout DLL that calls a SQL procedure, that will fire up a SQL Agant job that creates the OLAP roles.
Steven
Feb 26, 2009 at 3:21 AM
Thanks a lot for the reply Steven!  Do you happen to have any sample code, or could you tell me in which function you call the SP to create the roles?