PS2007 Cube Failing

[Chris Vas]

Tried to utilize an MDX Expression and now am unable to build cube. Deleted
MDX Expression, but am still receiving the error "The syntax for 'Number' is
incorrect". Anyone have any thoughts? I have deleted the cube, still with
no success.



Detailed error below - send it to the administrator for more detailed
troubleshooting.

<?xml version="1.0" encoding="utf-16"?>
<errinfo>
<general>
<class name="CBS message processor failed">
<error id="17004" name="CBSOlapProcessingFailure"
uid="8b15666e-efea-4ea2-854c-6db9d3cc337c" QueueMessageBody="Setting
UID=00007829-4392-48b3-b533-5a5a4797e3c9 ASServerName=MA803DBSD\SQL2005_DEV
ASDBName=ProjectServer2007AnalysisServicesRepository ASExtraNetAddress=
RangeChoice=2 PastNum=1 PastUnit=0 NextNum=1 NextUnit=0 FromDate=01/01/2007
00:00:00 ToDate=08/22/2007 00:00:00 HighPriority=False" Error="Analysis
Services session failed with the following error: Failed to process the
Analysis Services database ProjectServer2007AnalysisServicesRepository on the
MA803DBSD\SQL2005_DEV server. Error: Server: Operation completed with 210
problems logged.
Parser: The syntax for 'Number' is incorrect.
" />
</class>
<class name="Queue">
<error id="26000" name="GeneralQueueJobFailed"
uid="03eb924c-a718-40e1-afce-042d69f9032c"
JobUID="b4eb0720-6a93-49d2-b462-bafd963cc0b2" ComputerName="MA851EPMD"
GroupType="CBSRequest" MessageType="CBSQueueMessage" MessageId="2" Stage="" />
</class>
</general>
</errinfo>

 

[Gary L. Chefetz [MVP]]

You need to delete the custom field in which you created the MDX expression.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[Jonathan Sofer]

I have found that even if you delete the custom MDX fields in
PWA>Cube>Configuration, it still builds it into the cube.

My suggestion is to put the custom field name back in and spell it exactly
the same, put a very simple MDX formula that you know will work. Hopefully
since it is the exact same name as before, it will overwrite what is still
out there but will not fail this time around.

Let me know if that works.

Jonathan