Databases Reference
In-Depth Information
the set will be in dimension order). In AS2005, if only one member is invalid
and the other is valid, a range is constructed from the valid member to the
end of the level. An invalid left-hand member creates a range from the first
member in the level, and an invalid right-hand member creates a range to the
last member in the level. In AS2000, if either of the members is invalid, a
parse error occurs.
See also: MemberRange ()
Function and Operator Reference
A
AddCalculatedMembers (
set
)
Returns: set Extension: AS2000, AS2005
By default, when a set of members is specified using a function that re-
trieves a set based on metadata (such as .Members, .Children, Descend-
ants (), and so on), only base members are returned, even though calcu-
lated members may be within that range. The AddCalculatedMembers ()
function adds in all of the calculated members that are siblings of the
members specified within the
set.
Each calculated member that was not
already in the set is added in database order after its last sibling member
in the
set.
The
set
is limited to only one dimension. Note that this function
adds all calculated members defined, whether they were defined by
CREATE MEMBER at the server or at the client, or in the query through
WITH MEMBER.
See also: .AllMembers, StripCalculatedMembers ()
Aggregate (
set
[,
numeric value expression
])
Returns: number Standard
This function aggregates the cells formed by the set according to the de-
fault aggregation operator for any measures in context. If a numeric
value expression is provided, then this function sums the expression's
set of values over the cells. In the event that the cells are of a base
measure, the aggregation function specified for the measure is used. In
AS2000, if the aggregation functions of the measure are COUNT, MIN, or
MAX, then COUNT, MIN, or MAX, respectively, is the aggregation opera-
tion used; otherwise, the aggregation operation used is summation. In
Search WWH ::
Custom Search