Strictly equivalent to: PeriodsToDate( [Time].[Calendar].[Month], member ).
In our example, returns the three first days of [Feb 2010].
Query
Mtd([Time].[Calendar].[February 3 2010])
Result
{
[Time].[Calendar].[Day].[February 1 2010],
[Time].[Calendar].[Day].[February 2 2010],
[Time].[Calendar].[Day].[February 3 2010]
}
Assertion : MDX Equals
PeriodsToDate([Time].[Calendar].[Month],[February 3 2010])
Strictly equivalent to: PeriodsToDate( [Time].[Calendar].[Month], [Time].currentMember ).
Query
WITH
MEMBER period_names AS GENERATE( Mtd() as periods , periods.CurrentMember.Name, "-" )
SELECT
period_names ON 0
FROM
[Sales]
WHERE
[Time].[Calendar].[February 3 2010]
Result
| period_names |
| February 1 2010-February 2 2010-February 3 2010 |
Assertion : MDX Equals
WITH
MEMBER period_names AS GENERATE( Mtd( [Time].[Calendar].currentMember ) as periods , periods.CurrentMember.Name, "-" )
SELECT
period_names ON 0
FROM
[Sales]
WHERE
[Time].[Calendar].[February 3 2010]