Databases Reference
In-Depth Information
The Is operator is used to determine if two objects are equivalent. For ex-
ample, the expression
[Customers].CurrentMember
IS [All Customers].[Canada].[BC].[Vancouver]
will only return TRUE when the current customer member in the context is
Vancouver, BC. In Analysis Services, you can compare objects of any kind,
and you can compare objects with NULL as well to see if they exist. For ex-
ample, if the first month in the Time dimension is [Jan 2000], then the follow-
ing two expressions will return TRUE:
[Jan 2000].PrevMember IS NULL
[Jan 2000].Level IS [Time].[Month]
See also: IsEmpty (), IsValid ()
IsAncestor (
AncestorMember
,
StartingMember
)
Returns: boolean Extension:
AS2005, AS2000
This function returns true if the
AncestorMember
is indeed a proper an-
cestor of
StartingMember
, and false otherwise. No error is returned if the
two members are from different dimensions (just false).
See also: IsChild (), IsGeneration, IsSibling (), IsLeaf (), iif (), Is, .Ordinal
IsEmpty (
ValueExpression
)
Returns: boolean
Standard
This function returns true if the
ValueExpression
is NULL, and false oth-
erwise. Note that in Analysis Services, if the
ValueExpression
is a tuple
instead of a simple member reference, then it must be enclosed by par-
entheses to distinguish the use of parentheses for tuple construction
from parentheses for delimiting the argument to IsEmpty (), as in:
IsEmpty ( ([Measures].[Units],
[Time].PrevMember) )
Also, in Analysis Services, note that IsEmpty () will return false if a prop-
erty reference is not valid for the member (like IsEmpty
([Time].CurrentMember.Properties ("Mailing Address")). More generally,
Search WWH ::
Custom Search