David Duncan provide some great troubleshooting information while installing Dynamics GP's Analysis Cubes on SQL Server 2008. Make sure that you take a look over at I.B.I.S.' DynamicsCare blog.
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP