SSAS - MDX Queries

select
[Measures].[Internet Sales Amount] on columns,
ancestor([Customer].[Customer Geography].[Customer].[Crystal Zheng],[Customer].[Customer Geography].[City])
on rows
from [Adventure Works]
--alternate syntax
select
[Measures].[Internet Sales Amount] on columns,
ascendants([Customer].[Customer Geography].[Customer].[Crystal Zheng])
on rows
from [Adventure Works]
//positive lead and negative lag
select
{[Date].[Calendar].[Calendar Quarter].[Q1 CY 2003],
[Date].[Calendar].[Calendar Quarter].[Q1 CY 2003].lag(3)} on columns,
[Measures].[Reseller Sales Amount] on rows
from [Adventure Works]
//head
select
{[Measures].[Internet Sales Amount],[Measures].[Internet Tax Amount]} on columns,
head([Customer].[Customer Geography].[Country],5) on rows
from [Adventure Works]
//
select
{[Measures].[Internet Sales Amount],[Measures].[Internet Tax Amount]}
on columns,
{[Customer].[Customer Geography].[Country].[Germany],
[Customer].[Customer Geography].[Country].[Germany].nextmember.nextmember}
on rows
from
[Adventure Works]