Skip to Main Content
MDX Solutions: With Microsoft® SQL Server™ Analysis Services 2005 and Hyperion® Essbase, Second Edition
book

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

by George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi
March 2006
Intermediate to advanced content levelIntermediate to advanced
744 pages
16h 7m
English
Wiley
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional SQL Server™ Analysis Services 2005 with MDX

Professional SQL Server™ Analysis Services 2005 with MDX

Sivakumar Harinath, Stephen R. Quinn
Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Sivakumar Harinath, Matt Carroll, Sethu Meenakshisundaram, Robert Zare, Denny Guang-Yeu Lee
Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Irina Gorbach, Alexander Berger, Edward Melomed

Publisher Resources

ISBN: 9780471748083Purchase book