Databases Reference
In-Depth Information
For example, in Analysis Services, if the levels of the [Time] dimension
are [All], [Year], and [Month], then [Time].Levels (0) returns the [Time].
[All] level, and [Time].Levels (2) returns the [Time].[Month] level. In Ana-
lysis Services, you can obtain the number of levels in the dimension with
Dimension.
Levels.Count, which lets you refer to the leaf level by the ex-
pression
Dimension.
Levels (
Dimension.
Levels.Count).
LinkMember (
member
,
dimension
)
Returns: member Extension: AS2005,
AS2000
The LinkMember () function is used to reference a member in one hierarchy
based on a member from another related hierarchy. The hierarchies may
either be from the same dimension (where a dimension has multiple hierarch-
ies) or from different dimensions. (Remember that different hierarchies are
different dimensions in Microsoft OLAP/Analysis Services.) The members are
matched by key rather than by name, so members with the same key but with
different names will be linked. For example, the expression
Hierarchize (
Ascendants (
Linkmember ([Time].[Calendar].[Jan 1
1999],[Time].[Fiscal])
))
will return the ascendants in the fiscal hierarchy for the calendar hierarchy
member [Jan 1 1999].
LinRegIntercept (
set
,
y numeric expression
[,
x numeric expression
])
Returns: number
Standard
This function returns the intercept of the linear regression line calculated
from the given data points (where the regression line intersects 0). For
the linear equation y = ax + b, which will be determined over some set of
y and x, the values of the
y numeric expression
are evaluated over the
set to get the y values. If the
x numeric expression
is present, then it is
evaluated over the set to get the values of the x axis. Otherwise, the cells
formed by the set are evaluated within the current context and their val-
ues are used as the x values. Empty cells and cells containing text or lo-
Search WWH ::
Custom Search