MDX Query Syntax problem

Question

Hi,

May i know, what the problem,in this line of code

CAST("[Customer].[Username].[Username].[MEMBER_CAPTION]" AS VARCHAR(100)) AS UserName,

Executing the query ...
Query (5, 78) Parser: The syntax for 'UserName' is incorrect.

---

Pachi

Answer 1

Hello,

CAST is a T-SQL function, not a MDX one; also the rest like datatype and alias is T-SQL

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing