O'Reilly logo

MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition by Francesco Civardi, Dylan Hai Huang, Christopher Webb, Sivakumar Harinath, George Spofford

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required