Returns TRUE if the specified element validates successfuly.
IsValid ( member | tuple | set | layer | property )
| member | A member specification. |
| tuple | A tuple specification. |
| set | A set specification. |
| layer | A layer specification. |
| property | A property specification. |
The following example shows how IsValid can be used to check whether a given
property value is valid. It returns all Product dimension members
that have an Ounces attribute value of 12.
SELECT
Filter([Product].members,
IsValid([Product].CurrentMember.Ounces)
AND
[Product].CurrentMember.Ounces = 12)
ON COLUMNS
FROM Sample.Basic
The expression IsValid([Product].currentmember.Ounces) returns TRUE for
only those members in the Product dimension that have a valid property
value for [Ounces]. This eliminates ancestral members such as [Product]
and [Colas] that do not have the [Ounces] property defined because
they are not level-0 members of the Product dimension.
The second part of the AND condition in the filter selects only those members with
a value of 12 for [Ounces].
This query returns the following grid:
| 100-10 | 100-20 | 200-10 | 200-30 | 300-30 |
|---|---|---|---|---|
| 22777 | 5708 | 7201 | 4636 | 11093 |
IsValid([Jan].FirstChild)
returns FALSE, because [Jan] is a level-0 member, therefore it does not have any children.
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |