Qtd (MDX)

Returns a set of sibling members from the same level as a given member, starting with the first sibling and ending with the given member, as constrained by the Quarter level in the Time dimension.

Syntax

Qtd( [ Member_Expression ] )

Arguments

• Member_Expression
  A valid Multidimensional Expressions (MDX) expression that returns a member.

Remarks

If a member expression**is not specified, the default is the current member of the dimension of type Time (Time.CurrentMember).

The Qtd function is a shortcut function for the PeriodsToDate (MDX) function whose level expression argument is set to Quarter. That is, Qtd(Member_Expression) is functionally equivalent to PeriodsToDate(Quarter, Member_Expression).

Example

The following example returns the sum of the Measures.[Order Quantity] member, aggregated over the first two months of the third quarter of calendar year 2003 that are contained in the Date dimension, from the Adventure Works cube.

WITH MEMBER [Date].[Calendar].[First2MonthsSecondSemester2003] AS
    Aggregate(
        QTD([Date].[Calendar].[Month].[August 2003])
    )
SELECT 
    [Date].[Calendar].[First2MonthsSecondSemester2003] ON COLUMNS,
    [Product].[Category].Children ON ROWS
FROM
    [Adventure Works]
WHERE
    [Measures].[Order Quantity]

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
17 July 2006	Changed content: Updated syntax and arguments to improve clarity. Added updated examples.