Article ID: 936080
Article Last Modified on 6/21/2007
APPLIES TO
- Microsoft SQL Server 2005 Analysis Services
Bug #: 50001126 (SQL Hotfix)
SYMPTOMS
In Microsoft SQL Server 2005 Analysis Services Service Pack 2 (SP2), you create a database role that has the following permissions:
- You set the Read Definition database permission for the role.
- You set the Read access permission to a cube.
- You enable the Enable read-contingent permissions option for the cube.
- You specify a Multidimensional Expressions (MDX) expression for the read-contingent permissions.
When you browse the cube under the security context of this role, some values of measures unexpectedly appear as #N/A. However, in SQL Server 2005 Analysis Services Service Pack 1 (SP1), these values are displayed as the values that are derived from these measures.
CAUSE
This problem occurs because of a regression that was introduced in SQL Server 2005 SP2.
RESOLUTION
Cumulative update information
To resolve this problem, obtain the cumulative update package (build 3175) for SQL Server 2005 SP2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
936305 Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Keywords: kbpubtypekc kbqfe kbfix kbsql2005as kbexpertiseadvanced KB936080