Skip to Main Content
Professional Microsoft SQL Server 2012 Reporting Services
book

Professional Microsoft SQL Server 2012 Reporting Services

by Paul Turley, Robert M. Bruckner, Thiago Silva, Ken Withee, Grant Paisley
June 2012
Intermediate to advanced content levelIntermediate to advanced
912 pages
23h 35m
English
Wrox
Content preview from Professional Microsoft SQL Server 2012 Reporting Services

Appendix C

MDX Reference

This appendix provides information on aspects of the SQL Server 2008, 2008 R2, and 2012 implementations of the Multidimensional Expressions (MDX) language relevant to Reporting Services authors. The material provided here is intended to provide a quick reference, not to be fully instructional. Nor is this material intended to provide an overview of SQL Server Analysis Services. For a complete reference on these topics, refer to Professional Microsoft SQL Server 2012 Analysis Services with MDX (Wrox).

Object Identifiers

All objects within Analysis Services — cubes, cube dimensions, attribute hierarchies, user hierarchies, hierarchy levels, members, and so on — are referenced through an object identifier. An object identifier is a value containing between 1 and 100 characters. The first character of the object identifier must be a letter or underscore. Subsequent characters can be letters, numbers, or underscores. Object identifiers cannot contain spaces or special characters and cannot be a reserved keyword, as discussed in the next section. Identifiers adhering to these rules are called regular identifiers.

An object identifier violating one or more of these rules is known as a delimited identifier. A delimited identifier must be encapsulated by square brackets — known as the object's delimiters — for the identifier to be correctly interpreted. Although required for delimited identifiers, square brackets can also be used with regular identifiers.

Reserved ...

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

Microsoft SQL Server 2012 Reporting Services

Microsoft SQL Server 2012 Reporting Services

Stacia Misner
Microsoft® SQL Server 2012 Unleashed

Microsoft® SQL Server 2012 Unleashed

Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein

Publisher Resources

ISBN: 9781118237137Purchase book