访问旁系亲属与级别内导航
1 访问旁系亲属
1.1 Ancestor(member, level |distanct),访问某一层级的祖先成员
1.2 Ancestors(member),返回成员的所有祖先成员
1.3 Descendants(……),访问在指定级别或距离上的后代
1.4 Cousin(member, ancestoreMember),返回在父成员【ancestoreMember】下,与指定成员【member】具有相同的相对位置的子成员
例:获取同期成员
with
member[memberName] as [Date].[年-月-日].currentMember.uniqueName
member[memberNameYOY] as
//[Date].[年-月-日].currentMember.parent.prevMember.uniqueName
cousin(
[Date].[年-月-日].currentMember,
[Date].[年-月-日].currentMember.parent.prevMember
).uniqueName
select
{
[Measures].[In Count],
[memberName],
[memberNameYOY]
}on 0,
(
[Date].[年-月-日].[Month NumOf Year].members
)on 1
from
[Park]
注意比较注释与正常的查询结果
2 级别内导航
2.1 PrevMember,同一级别的前一成员
2.2 NextMember,同一级别的后一成员
2.3 Lag(n),同一级别前第n个位置的成员
2.4 Lead(n),同一级别后第n个位置的成员
例:
with
member [nextMember]as [Date].[年-月-日].currentMember.nextMember.uniqueName
member [lagMember]as [Date].[年-月-日].currentMember.lag(1).uniqueName
select
{
[nextMember],
[lagMember]
}on 0,
(
[Date].[年-月-日].[Month NumOf Year].members
)on 1
from
[Park]