Microsoft KB Archive/914098

= Measure data returns &quot;#N/A&quot; 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 =

Article ID: 914098

Article Last Modified on 6/28/2006

-

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 &quot;#N/A&quot; 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 &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005as kbsql2005bi KB914098

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.