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

NA returns when you run a multi-subselect query

· 52CE 我爱测

This article discusses a problem that occurs when you run a multi subselect query in SQL Server Analysis Services.

This article introduces a problem that occurs when you run a multi-subselect query in SQL Server Analysis Services.

Original product version:   SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012
Original KB number:   4100766

Symptoms

Consider the following scenario:

  • You install Analysis Services in Multidimensional mode on an instance of SQL Server 2012, SQL Server 2014, SQL Server 2016, or SQL Server 2017.
  • There is a database in this instance.
  • You create a role with cell security read permission for this database.
  • You execute a query that contains a subselect with multiple members.

In this situation, you get #N/A cell values for the measure if the multi-member subselect is at or below the granularity, and the higher-level members whose values are affected by the cell security read permissions are applied to them.

Cause

This behavior is by design. This design makes sure that the database does not expose real cell values that are secured by the cell security.

Applies to

  • SQL Server 2012
  • SQL Server 2012 Analysis Services
  • SQL Server 2014
  • SQL Server 2014 Business Intelligence
  • SQL Server 2016
  • SQL Server 2017 on Windows

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 07/22/2020
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

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

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