Execution Location Property
This property determines the location of query resolution: the client application, server, or a combination of both.
The following values are available.
|0||Default. For compatibility with earlier versions, this means the same as Value 1. The meaning of this default value is subject to change in future versions.|
|1||PivotTable® Service selects the query execution location (client application or server) that will provide the best performance.|
|2||Queries are executed on the client application.|
|3||Queries are executed on the server. (Queries that contain session-scoped calculated members, user-defined sets, or user-defined functions are exceptions.)|
This property's value is used when a session is established, and the value can be changed during the session.