SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Multidimensional Expressions (MDX) Reference

MDX Language Reference

MDX Function Reference

AddCalculatedMembers

Aggregate

AllMembers

Ancestor

Ancestors

Ascendants

Avg

Axis

BottomCount

BottomPercent

BottomSum

CalculationCurrentPass

CalculationPassValue

Children

ClosingPeriod

CoalesceEmpty

Correlation

Count (Dimension)

Count (Hierarchy Levels)

Count (Set)

Count (Tuple)

Cousin

Covariance

CovarianceN

Crossjoin

Current

CurrentMember

CustomData

DataMember

DefaultMember

Descendants

Dimension

Dimensions

Distinct

DistinctCount

DrilldownLevelBottom

DrilldownLevelTop

DrilldownMember

DrilldownMemberBottom

DrilldownMemberTop

DrillupLevel

DrillupMember

Error

Except

Exists

Extract

Filter

FirstChild

FirstSibling

Generate

Head

Hierarchize

Hierarchy

IIf

Intersect

IsAncestor

IsEmpty

IsGeneration

IsLeaf

IsSibling

Item (Member)

Item (Tuple)

KPIGoal

KPIStatus

KPITrend

KPIWeight

KPICurrentTimeMember

KPIValue

Lag

LastChild

LastPeriods

LastSibling

Lead

Leaves

Level

Levels

LinkMember

LinRegIntercept

LinRegPoint

LinRegR2

LinRegSlope

LookupCube

Max

MeasureGroupMeasures

Median

Members (Set)

Members (String)

MemberToStr

MemberValue

Min

Mtd

Name

NameToSet

NextMember

NonEmpty

NonEmptyCrossjoin

OpeningPeriod

Order

Ordinal

Parent

PeriodsToDate

Predict

PrevMember

Properties

Qtd

Rank

Root

SetToArray

SetToStr

Siblings

Stddev

StddevP

Stdev

StdevP

StripCalculatedMembers

StrToMember

StrToSet

StrToTuple

StrToValue

Subset

Sum

Tail

This

ToggleDrillState

TopCount

TopPercent

TopSum

TupleToStr

Union

UniqueName

UnknownMember

Unorder

UserName

ValidMeasure

Value

Var

Variance

VarianceP

VarP

VisualTotals

Wtd

Ytd

Minimize

0 out of 1 rated this helpful - Rate this topic

Error (MDX)

SQL Server 2005

Updated: 17 July 2006

Raises an error, optionally providing a specified error message.


Error( [ Error_Text ] )

Error_Text: A valid string expression containing the error message to be returned.

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Release	History
17 July 2006	Changed content: Updated syntax and arguments to improve clarity.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.