这个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,...20...
显示全部这个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.
收起