Extracting first month

#1

I have this qry

WITH
SET [LatestMonth] AS
'TAIL(NONEMPTYCROSSJOIN([Time].[Standard].[Month].Members,
{[Country].[Country].[Bahrain]}, 1), 1)'
SELECT
{[Measures].[Coverage]} ON 0,
CROSSJOIN({[Country].[Country].[Bahrain]}, [LatestMonth]) ON 1
FROM [Cross Country]

This succesfully gets me the last month, what can I do to get the first
month. (i.e. the opposite to tail)

Thanks

Denver

#2

Hi Denver,
The Function opposite to TAIL is HEAD.
Ta
Paul

"Denver" wrote:

Quote:

I have this qry

WITH
SET [LatestMonth] AS
'TAIL(NONEMPTYCROSSJOIN([Time].[Standard].[Month].Members,
{[Country].[Country].[Bahrain]}, 1), 1)'
SELECT
{[Measures].[Coverage]} ON 0,
CROSSJOIN({[Country].[Country].[Bahrain]}, [LatestMonth]) ON 1
FROM [Cross Country]

This succesfully gets me the last month, what can I do to get the first
month. (i.e. the opposite to tail)

Thanks

Denver

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Extracting first month

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Extracting first month - 12-20-2005 , 08:46 AM

RE: Extracting first month - 12-20-2005 , 11:26 AM