How to fix the Error?

[Nadya]

I have to use for my PivotCube the SQL query
SELECT A.WORKORDER, A.SDESC, A.PLANTNO, C.SDESC "PLANT DESC",....
And I have got the Error when I try to create New cube and choose field "PLANT DESC" for dimention
The Error is " Expected token 'eof' found 'NAME' .//Plant->DESC<- "

Details: Error happened on runtime in the procedure TCBCubeDef.GetMapSlices(FRoot: IXMLDOMElement);
on the process
DimensionNode:= (ChildNode.getElementsByTagName(PivotMap.Dimensions[dimCounter].AliasName).item[0] as IXMLDOMElement);
What I have to do? There is exists only the way to change sql query or maybe you can help to find me the another wat to solve this problem?
Thank you.

[Guillaumep]

I'm probably wrong but your SQL should be (add AS) :

SELECT A.WORKORDER, A.SDESC, A.PLANTNO, C.SDESC AS "PLANT DESC" ...

Have a nice day,
Guillaume