MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition

Appendix B. Connection Parameters That Affect MDX

This Appendix collects all of the connection parameters that affect MDX usage and results in Microsoft Analysis Services 2000 and Analysis Services 2005. The OLE DB for OLAP and ADO MD identifiers for them are both provided. This includes most of the implemented connection parameters for Analysis Services.

A list of the connection parameters and the Microsoft product versions that implement them are shown in Table B-1. The fact that no client-side processing of queries takes place in Analysis Services 2005 means that several connection string parameters that controlled the behavior of this functionality in Analysis Services 2000 are now deprecated.

Table B-1. Connection Properties Affecting MDX and Query Results^*

ADO MD NAME	OLE DB FOR OLAP PROPERTY ID	ANALYSIS SERVICES 2000	ANALYSIS SERVICES 2005
[a]
Auto Synch Period	DBPROP_MSMD_AUTOSYNCHPERIOD	Y	D
Cache Policy	DBPROP_MSMD_CACHEPOLICY	Y	D
Cache Ratio	DBPROP_MSMD_CACHERATIO	Y	D
Cache Ratio2	DBPROP_MSMD_CACHERATIO2	Y	D
CompareCaseNot SensitiveStringFlags	DBPROP_MSMD_COMPARECASENOT SENSITIVESTRINGFLAGS	Y	Y
CompareCase SensitiveStringFlags	DBPROP_MSMD_COMPARECASE SENSITIVESTRINGFLAGS	Y	Y
CreateCube	DBPROP_MSMD_CREATECUBE	Y	Y
CustomData	DBPROP_MSMD_CUSTOMDATA	N	Y
Data Source	DBPROP_INIT_ DATASOURCE	Y	Y
Default MDX Visual Mode	DBPROP_MSMD_DEFAULT_MDX_VISUAL_MODE	Y	Y
Execution Location	DBPROP_MSMD_EXECLOCATION	Y	D
Initial Catalog	DBPROP_INIT_CATALOG	Y	Y
InsertInto	DBPROP_MSMD_INSERTINTO	Y	Y
Large Level Threshold	DBPROP_MSMD_LARGE_LEVEL_THRESHOLD ...