PivotTable Service Properties

Analysis Services Programming (SQL Server 2000)

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
Restricted Client Property	Restricts PivotTable Service from creating local cubes or running deeply recursive queries.
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