随笔分类 -  MDX

MDX
MDX 用NonEmpty过滤度量为NULL的数据
摘要:1.未用NonEmpty的MDXselect {( [Measures].[职位审批 总数])}on 0,{ [Dim Job].[Job Title].children} * {[Dim Job].[Job Id].&[41164]}//,[Dim Job].[Job Id].&[390]* {[Dim Job].[Job Status Alias].children}*{[Dim Job].[Department key].children} *{[Dim Job].[Head Count].children } *{[Dim Job].[Hr Duty User Key] 阅读全文
posted @ 2013-05-31 13:47 huyg 阅读(832) 评论(0) 推荐(0)
MDX查询维度中多个属性
摘要:select a on 0,{ [Dim Job].[Job Title].children} * {[Dim Job].[Job Id].children}* {[Dim Job].[Job Status Alias].children} on rows from [ASA Recruitment V2] 阅读全文
posted @ 2013-05-28 17:32 huyg 阅读(537) 评论(0) 推荐(0)