Measure data returns "#N/A" when you query a cube under a database role that has read-only access to the cells in the cube in SQL Server 2005 Analysis Services (914098)


The information in this article applies to:

  • Microsoft SQL Server 2005 Analysis Services

SYMPTOMS

Consider the following scenario. You create a database role for a Microsoft SQL Server 2005 Analysis Services (SSAS) database. Then, you enable the Enable Read Permissions option to grant read-only access to the cells in the selected cube. However, you do not specify a Multidimensional Expressions (MDX) expression for the Allow reading of cube content option. In this scenario, all measure data returns "#N/A" when you query the cube under the database role.

CAUSE

This problem occurs because the MDX expression is evaluated as the false value of the Boolean type. When this option value is false, all the cell data cannot be accessed.

RESOLUTION

To resolve this problem, specify a valid MDX expression for the Allow reading of cube content option. For example, use one of the following MDX expressions to access all measures in the cube:
  • NOT Measures.Currentmember IS NULL
  • 1=1
  • 1
  • -1

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MajorLast Reviewed:6/28/2006
Keywords:kbExpertiseAdvanced kbsql2005bi kbsql2005as kbtshoot kbprb KB914098 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.