Getting error after deleting MDX Expressions and building OLAP cub

[srout]

Hi

I have a wired issue. In Project Server 2007. I added couple of MDX
Expressions for Calculated Mesures fields, but got error on expression
syntax. Now, I deleted these expressions and re-building the cube. Getting
following errors on those Expressions even though they don't exists any more.

Can you please HELP???????
How to clen them up for good? Any manual or other process at all or any
thing else I can do.

CUBE BUILDING ERROR DETAILS:
--------------------------------------

===== Determining database and cube structure =====
[1/21/2009 5:47 PM] Cube build initialization started
[1/21/2009 5:47 PM] OLAP database and cube structure was determined
successfully
===== Building database and cubes =====
[1/21/2009 5:47 PM] Cube build session started
[1/21/2009 5:47 PM] Analysis Services session started
[1/21/2009 5:48 PM] 1 of the NT accounts that correspond to users that have
'View Olap Data' permission could not be added to the Project Server default
OLAP role 'ProjectServerViewOlapDataRole'
[1/21/2009 5:48 PM] Analysis Services session completed successfully
===== Verifying and running post-build server event handler =====
[1/21/2009 5:48 PM] Verifying and running post-build server event handler
===== Processing OLAP database =====
[1/21/2009 5:48 PM] Process OLAP database session started
[1/21/2009 5:48 PM] Analysis Services session started
[1/21/2009 5:50 PM] Analysis Services session failed with the following
error: Failed to process the Analysis Services database emrproject on the
EMRPROJECT server. Error: Parser: The following syntax error occurred during
parsing: Invalid token, Line 1, Offset 74, '.
MdxScript(Resource Timephased) (1, 67) Parser: The syntax for '-' is
incorrect.

===== Process Completed =====
[1/21/2009 5:50 PM] Failed to build the OLAP cubes. Error: Analysis Services
session failed with the following error: Failed to process the Analysis
Services database emrproject on the EMRPROJECT server. Error: Parser: The
following syntax error occurred during parsing: Invalid token, Line 1, Offset
74, '.
MdxScript(Resource Timephased) (1, 67) Parser: The syntax for '-' is
incorrect.

Regards
SRout

 

[Malik Al-Shayeb]

Hi

The MDX you have added is still their in the cube XMLA files open the
analysis service iv visual studio and remove it , then reprocess the cubes
or you can try the easy way and change the analysis data base to be created
in the cube build settings

and please make sure that you have all the updates installed on the server .
Best Regards Malik