Returns the start date for a date-time dimension member.
Syntax
GetFirstDate ( member )| Parameter | Description |
|---|---|
member | A member from a date-time dimension. |
Notes
This function returns #MISSING if the input member is not from a date hierarchy in a Time-Date tagged dimension.
The return value is a number representing the input date. The number is the number of seconds elapsed since midnight, January 1, 1970.
This function is applicable only to aggregate storage databases.
Example
The following query returns sales for the first week of April, 2004.
SELECT
{[Sales]}
ON COLUMNS,
{DateToMember(
GetFirstDate ([Apr 2004]),
[Time dimension].Dimension,
[Time dimension].[Weeks]
)}
ON ROWS
FROM MySamp.basic;