Analysis Services Programming
PivotTable Service Properties
Properties in PivotTable® Service can be referred to by either property name or property ID. When setting or reading the value of a property using Microsoft® ActiveX® Data Objects (ADO), use the property name. When setting or reading the value of a property using OLE DB, use the property ID. The property ID is listed in the individual reference topic for each property.
Important Some property names contain embedded spaces; others do not. Use the property name exactly as it is listed under the Property Name heading in the property detail topic.
The following table lists the property names and property IDs that PivotTable Service supports. For more information, see the OLAP portion of the OLE DB specification.
| Property name | Description |
| ArtificialData Property | Reserved for future use |
| Authenticated User Property | Reserved for future use |
| Auto Synch Period Property | Controls the frequency (in milliseconds) of client/server synchronization |
| Cache Policy Property | Reserved for future use |
| Cache Ratio Property | Reserved for future use |
| Client Cache Size Property | Controls the amount of memory used by the client cache |
| CompareCaseNotSensitiveStringFlags Property | Adjusts case-insensitive string comparisons for a specified locale |
| CompareCaseSensitiveStringFlags Property | Adjusts case-sensitive string comparisons for a specified locale |
| Connect Timeout Property | Determines the maximum amount of time the client application will attempt to connect to the server before timing out |
| CreateCube Property | The CREATE CUBE statement to create a local cube file |
| Data Source Property | The name of the server computer or local cube file |
| Datasource Connection Type Property | Describes the type of connection that is currently active |
| Default GUID Dialect Property | Controls the precedence in which language dialects are applied when resolving queries |
| Default Isolation Mode Property | Controls whether the isolation level is isolated or determined by the cursor type requested by the rowset properties |
| Default MDX Visual Mode Property | Determines the default behavior of visual totals |
| Distinct Measures By Key Property | Reserved for future use |
| Do Not Apply Commands Property | Reserved for future use |
| Execution Location Property | Determines the location of query resolution: the client application, server, or a combination |
| Initial Catalog Property | The name of the initial database (catalog) |
| InsertInto Property | The INSERT INTO statement used to populate a local cube file created with the CREATE CUBE statement |
| Large Level Threshold Property | Determines the definition of large level for client/server handling of level members |
| Locale Identifier Property | The locale ID of preference for the client application |
| Log File Property | Specifies a file name for logging queries |
| MDX Calculated Members Mode Property | Reserved for future use |
| MDX Compatibility Property | Determines how empty members are treated for ragged and unbalanced hierarchies |
| MDX Object Qualification Property | Describes how object names are qualified in Microsoft SQL Server™ 2000 Analysis Services |
| MDX Unique Name Style Property | Determines the technique for generating unique names |
| Mining Execution Location Property | Determines the location of query resolution for data mining queries |
| Mining Location Property | Determines the directory in which a local data mining model will be created |
| Mining Persistence Format Property | Determines how data mining models are saved |
| OLE DB for OLAP Version Property | Indicates the version of the OLE DB provider |
| Password Property | Specifies the password to use when connecting using HTTP |
| Provider Property | A predefined string containing other initialization properties |
| Read Only Session Property | Reserved for future use |
| Roles Property | Specifies a comma-delimited string of the role names by which a client application connects to the server |
| Safety Options Property | Determines how security for user-defined functions is handled |
| Secured Cell Value Property | Determines the type of return value that results from a reference to a secured cell |
| Show Hidden Cubes Property | Reserved for future use |
| Source_DSN Property | The OLE DB connection string, ODBC connection string, or ODBC data source name (DSN) for the source relational database; used only when creating a local cube file |
| Source_DSN_Suffix Property | Used to specify DSN properties for creating local cubes that should not be stored as part of the local cubes structure, such as the user ID and password for the local cube's data source |
| SQL Compatibility Property | Reserved for future use |
| SSPI Property | Determines the security package to use during the session |
| UseExistingFile Property | Determines whether a local cube file is overwritten if the connection string contains CREATE CUBE and INSERT INTO statements |
| User ID Property | Specifies a valid user name, such as a valid domain logon or local logon |
| Writeback Timeout Property | Determines the maximum amount of time the client application will attempt to communicate updates to a writeback table on the server before timing out |