使用MDX查询列出维度成员 [英] List dimension members with MDX query

问题描述

是否有一种方法可以列出维度成员而无需获取每个成员的默认度量?

Is there a way to list dimension members without fetching default Measure for each member?

推荐答案

您不能在相反的轴上选择任何内容:

You could SELECT nothing on the opposite axis:

SELECT
  { } on 0,
  { DESCENDANTS([Dimension].[Hierarchy]) } on 1
FROM [Cube]

选择一个空集可防止SSAS在相反的轴上添加默认量度.

SELECTing an empty set prevents SSAS from adding the default measure on the opposite axis.

这篇关于使用MDX查询列出维度成员的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！