fbpx

dtAsOf (MDX+)

Returns the member matching the current day or daytime.

Parameters

Name Type Cardinality Default value
  member-expression  one   
date  date-expression  one   

Return

member

Description

This functions returns a member matching the the year, month and day of the parameters

dtAsOf( [Time].[Calendar].[Day], 2008, 10, 25 ) , note that both day and month start at 1

This function is very similar to LookupByKey

See Also

CompactSet LookupByKey dtAsOf dtAsOfToday dtNextDay dtNextWeek dtNextMonth dtNextQuarter dtNextYear dtPreviousDay dtPreviousWeek dtPreviousMonth dtPreviousQuarter dtPreviousYear dtPlusDays dtPlusWeeks dtPlusMonths dtPlusQuarters dtPlusYears dtMinusDays dtMinusWeeks dtMinusMonths dtMinusQuarters dtMinusYears dtFirstDayOfWeekOfMonth dtFirstDayOfWeekOfQuarter dtFirstDayOfWeekOfYear dtLastDayOfWeekOfMonth dtLastDayOfWeekOfQuarter dtLastDayOfWeekOfYear dtNthDayOfWeekOfMonth dtNthDayOfWeekOfQuarter dtNthDayOfWeekOfYear dtDatesWeek dtDatesWeekend dtDatesWorkweek dtDatesWtd dtDatesMtd dtDatesQtd dtDatesYtd dtDatesItd dtDatesWfd dtDatesMfd dtDatesQfd dtDatesYfd dtWithDayOfWeek dtWithDayOfMonth dtWithDayOfYear dtWithMonthOfYear dtWithYear dtWithTime

Examples

Special Examples (errors, null, ...)

Since Version

6.7.5

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.