Databases Reference
In-Depth Information
This function returns the dimension that contains Member.
Dimensions (
numeric expression
)
Returns: dimension Extension:
AS2005, AS2000
This function returns the dimension whose zero-based position within the
cube is
numeric expression.
Note that the Measures dimension is always
Dimensions (0), while the order of the other dimensions depends on the
order in which they were added to the cube when it was being construc-
ted (and/or modified).
Dimensions (
string expression
)
Returns: dimension Extension: AS2005,
AS2000
This function returns the dimension whose name is given by string ex-
pression.
See also:
Dimension
.Name
Distinct (
set
)
Returns: set Standard
This function removes any duplicates from the
set.
The first instance of
each tuple is retained in the order in which it appears.
See also: DistinctCount (), Except (), Extract ()
DistinctCount (
set
)
Returns: number (integer) Extension: AS2005, AS2000
This function counts the distinct, nonempty tuples in a set. It is equivalent
to Count (Distinct (set),EXCLUDEEMPTY). Only a measure can use this
function. If you define a calculation on another dimension that uses
DistinctCount (), you will get a syntax error. (If you want this functionality
on another dimension, you can use the equivalent Count (
…
) expres-
sion.)
When this function is used to calculate a cell, the distinct tuples in
set
are
determined, and the nonempty cells formed by intersecting those tuples
with the current member in every other dimension are counted. This
function can be used to simulate the DistinctCount measure aggregation
type in Analysis Services, but its strength is when you want the distinct
count along only a subset of cube dimensions (one or two), when you are
Search WWH ::
Custom Search