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

最新推荐文章于 2020-10-13 15:45:27 发布

weixin_30438813

最新推荐文章于 2020-10-13 15:45:27 发布

阅读量158

点赞数

原文链接：http://www.cnblogs.com/rav009/p/5131090.html

版权

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]

转载于:https://www.cnblogs.com/rav009/p/5131090.html