Report Studio问题

xiaoerp

UDA-SQL-0458 PREPARE 失败，因为此查询要求在本地处理数据。 尚未启用允许本地处理的选项。 UDA-SQL-0462 数据库不支持 OLAP 函数“sum”。 此操作要求在本地处理数据。

本人是新手 求解答...

xiaoerp

Resolving the problem:
Changing the processing to Limited Local processing from Database Only Processing


Steps:
For Situation # 1 (Report Studio):
1.Open the report in Report Studio
2.Select the query
3.Under Properties --> Query, change Processing to Limited Local
4.Save the report


For Situation # 2 (Framework Manager):
Switch to Limited Local processing on the data source in the Framework Manager Model and re-test. Be aware that this may cause the additional errors mentioned in the Error messages section for Situation #2 above. If this occurs:

Verify that the key values used in the join are not of the data type RAW, which is not supported by Framework Manager. This means Framework Manager is not able to perform the join after loading the data for local processing.
Use the cast function to cast the RAW data type to a data type which is supported by Framework Manager