filter:[Calenddar Year Month]=[YM] ？该如何转换数据类型?

这个filter:[Calenddar Year Month]=[YM] 错在哪？该如何转换数据类型?


[LAst 7month] item－＞ _add_months (current_date,-7)
［YM］item －＞extract(year, [LAst 7month]) * 100 + extract(month, [LAst 7month])
   ( 值是: 201408)

[Calenddar Year Month]-> 201401,...201503


但这个filter:[Calenddar Year Month]=[YM] 出现error message:

多谢！！


UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled.
UDA-SQL-0475 The OLAP function 'sum' contains a clause (AT or PREFILTER) that is not supported by the database. This operation requires local processing of the data.
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'.
UDA-SQL-0458 PREPARE failed because the query requires local processing of the data. The option to allow local processing has not been enabled.
UDA-SQL-0475 The OLAP function 'sum' contains a clause (AT or PREFILTER) that is not supported by the database. This operation requires local processing of the data.