获取层次结构值名称mdx [英] Get hierarchies valuesName mdx

问题描述

我在下面创建了这样的层次结构:

I created a hierarchies like this photo below:

http://i.stack.imgur.com/ErOXQ.png

在MDX查询上

Select [AccSetting].[UserN].[UserN] ON 1
FROM [Olap_report]
Where [AccSetting].[AgID].[115]

此查询返回所有UserN是AgID 115的子级.但我想完全返回AgID =115的UserN吗?

This query return all UserN are children of AgID 115. but I want to return exactly UserN of AgID =115?

推荐答案

我想我现在明白了-名称是该成员的财产.

Think I understand now - the name is is a property of the member.

创建一个返回该属性的自定义度量.

Create a custom measure that returns the property.

WITH 
  MEMBER [Measures].[NameColumn] AS
    [AccSetting].[AgID].CURRENTMEMBER.Member_Name
  MEMBER [Measures].[NameColumn2] AS
    [AccSetting].[AgID].CURRENTMEMBER.Name
SELECT
  {
   [Measures].[NameColumn]
  ,[Measures].[NameColumn2]
  } ON 0,
  [AccSetting].[AgID].[115] ON 1
FROM [Olap_report]

对msdn的引用: https://msdn.microsoft.com/en-us/library/ms145583.aspx

修改

首先检查成员是否存在:

First check the member exists:

SELECT
  {
    [Measures].[<add measure here>],
    [Measures].[<add measure here>]
  } ON 0,
  {
   [AccSetting].[AgID].[115],
   [AccSetting].[AgID].[113]
  } ON 1
FROM [Olap_report]

这篇关于获取层次结构值名称mdx的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！