mdx 根据维度Hierarchy节点的名字来filter节点,搜索节点

with 
MEMBER [Measures].[Values1] AS [Employee - Owner].[Finance].currentmember.properties('name')
set mm as filter([Employee - Owner].[Finance].allmembers,INSTR([Employee - Owner].[Finance].currentmember.name,'P10074766')>0)
SELECT {[Measures].[Values1]} ON 0,
mm ON 1
FROM   [Cube]
WHERE  ({[Employee - Owner].[Person Status].&[Active],[Employee - Owner].[Person Status].&[Active contingent]},
[Time - UTC].[Fiscal].[Month].&[2014]&[8])

补充一段根据唯一ID获取name的例子:

with   
MEMBER [Measures].[Values1] AS [Service Offering].[CTS Offering].currentmember.properties('name')  
set mm as filter([Service Offering].[CTS Offering].allmembers,[Service Offering].[CTS Offering].currentmember.properties('key') ='263781')  
SELECT {[Measures].[Values1]} ON 0,  
mm ON 1  
FROM   [CUBE]