Mondrian错误:没有函数匹配签名'+ & lt; String> & # 39;

Question

得到上述mdx查询的错误:

With 
member [Measures].[MTD1] as 
Sum({StrToMember('[Year Month Day].[Date].&[' + FORMAT(Now(), 'yyyy') + '-' + FORMAT(Now(),'mm') + '-01' + ']')
: StrToMember('[Year Month Day].[Date].&[' + FORMAT(Now(), 'yyyy') + '-' + FORMAT(Now(),'mm') + FORMAT(Now(),'dd') + ']')}
, [Measures].[Amount])
member [Measures].[MTD2] as
Sum({StrToMember('[Year Month Day].[Date].&[' + FORMAT(Now(), 'yyyy') + '-' + FORMAT(dateadd('mm',-1,now())) + '-01' + ']')
: StrToMember('[Year Month Day].[Date].&[' + FORMAT(Now(), 'yyyy') + '-' + FORMAT(dateadd('mm',-1,now())) + FORMAT(Now(),'dd') + ']')}
, [Measures].[Amount])
member [Measures].[%MTD Growth] as
([Measures].[MTD1]-[Measures].[MTD2])/[Measures].[MTD1], FORMAT_STRING='0.00%'
Select {[Measures].[Amount],[Measures].[MTD1],[Measures].[MTD2],[Measures].[%MTD Growth]} ON COLUMNS,
[Transaction Place].Members ON ROWS
from [TXNSumCube]

日期存储为yyyy-mm-dd

Answer 1

对蒙德里安的"+",而是使用"| |"。