大网数据广告活动
数据库与应用安全

No properties and members of Dimension Hierarchy

· 52CE 我爱测

This article provides a workaround for the no results error that occurs when you try to get the properties and members of a Dimension Hierarchy by using XMLA script.

This article helps you work around the problem that occurs when you try to get the properties and members of a Dimension Hierarchy by using XML for Analysis (XMLA) script.

Original product version:   SQL Server 2016 Business Intelligence, SQL Server 2016 Analysis Services
Original KB number:   4038458

Symptoms

Assume that you have Microsoft SQL Server 2016 Analysis Services (SSAS 2016) installed. When you try to obtain the properties of a specific Dimension Hierarchy and its members by using XMLA script in SSAS 2016, no results are returned.

Note:

  • The same XMLA script works in SQL Server 2014 Analysis Services or earlier versions of SQL Server Analysis Services.
  • This issue only occurs when HierarchyUniqueNameStyle is set to ExcludeDimensionName.

Cause

This issue occurs because value ExcludeDimensionName was meant only for supporting old databases, such as SQL Server 2000 or 2005. If HierarchyUniqueNameStyle is set to ExcludeDimensionName, any XMLA request that includes DIMENSION_UNIQUE_NAME in the RestrictionList produces empty results.

Workaround

To work around this issue, set the value of HierarchyUniqueNameStyle to IncludeDimensionName in the cube dimension object.

Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / IT Pro troubleshooting
适用范围
See source applicability · Source date 08/05/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。