I have no experience with MDX and it appears that during the cube building process for Project Server 2007 there seems to be some deficient MDX scripts.ÃÂ I looked at the SASS logs with no luck andÃÂ looked in the application logs with no luck.ÃÂ I scripted out the problematic cube MSP_Portfoilio_Analyzer and found the 'Reported' syntax but don't really know how to correct or if there is even a problem.ÃÂ The cube has built in the past with no problems.ÃÂ Any help would be appreciated.
Server build is as follows:
Microsoft SQL Server 2005 - 9.00.3200.00 (X64)ÃÂ ÃÂ OctÃÂ 2 2007 12:23:02ÃÂ ÃÂ Copyright (c) 1988-2005 Microsoft CorporationÃÂ Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)ÃÂ ÃÂ
The server has both SQL Server and SSAS installed.
View Complete Post