Analysis Services Programming
Execution Location Property
This property determines the location of query resolution: the client application, server, or a combination of both.
Property Name
Execution Location
Property ID
DBPROP_MSMD_EXECLOCATION
Remarks
The following values are available.
| Value | Description |
|---|---|
| 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.