SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Analysis Services
Technical Reference
Query and Expression 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
CASE Statement
Children
ClosingPeriod
CoalesceEmpty
Correlation
Count (Dimension)
Count (Hierarchy Levels)
Count (Set)
Count (Tuple)
Cousin
Covariance
CovarianceN
Crossjoin
Current
CurrentMember
CurrentOrdinal
CustomData
DataMember
DefaultMember
Descendants
Dimension
Dimensions
Distinct
DistinctCount
Divide
DrilldownLevel
DrilldownLevelBottom
DrilldownLevelTop
DrilldownMember
DrilldownMemberBottom
DrilldownMemberTop
DrillupLevel
DrillupMember
Error
Except
Exists
Extract
Filter
FirstChild
FirstSibling
Generate
Head
Hierarchize
Hierarchy
IIf
Instr
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
LinRegVariance
LookupCube
Max
MeasureGroupMeasures
Median
Members (Set)
Members (String)
MemberToStr
MemberValue
Min
Mtd
Name
NameToSet
NextMember
NonEmpty
NonEmptyCrossjoin
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parent
PeriodsToDate
Predict
PrevMember
Properties
Qtd
Rank
RollupChildren
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
Expand Minimize
This topic has not yet been rated - Rate this topic

VarP (MDX)

SQL Server 2012

Returns the population variance of a numeric expression evaluated over a set, using the biased population formula (dividing by n-1).

Copy 

          

VarP(Set_Expression [ ,Numeric_Expression ] )
Set_Expression

A valid Multidimensional Expressions (MDX) expression that returns a set.

Numeric_Expression

A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

The VarP function returns the biased variance of a specified numeric expression, evaluated over a specified set.

The VarP function uses the biased population formula, while the Var function uses the unbiased population formula.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.