Contents

1 MDX


[edit]

1 MDX #


WITH MEMBER [InternetUnitPrice] AS
(
	IIF
	(
		IsLeaf([Date].[Calendar Date].CurrentMember)
	,	[Date].[Calendar Date].CurrentMember
	,	[Date].[Calendar Date].CurrentMember.LastChild
	)
	,	[Measures].[Internet Sales-Unit Price]
)
SELECT
	{
		[InternetUnitPrice]
	,	[Measures].[Internet Sales-Unit Price]
	} ON 0
,	{
		[Date].[Calendar Date].Members
	} on 1
FROM [Analysis Services Tutorial]