February 28, 2011 at 8:11 am
I inherited an SSAS cube in SQL Server 2008. The former developer had partially created the relationships in the cube between dimensions and measures for dynamic dimension security. I used a book "Expert Cube Development with Microsoft SQL Server 2008 Analysis Services" to attempt to complete the task. It has a section for creating this dynamic dimension security with the exact relationships between dimensions and measures as I have in my cube. The last piece was to open the Dimension Data tab in the role manager for my group (project managers) and create an MDX script between the dimensions and a measure. Here is the script:
NonEmpty (
[Special Project Details].[Project Code].Members,
(
StrToMember ("[User Ids].[User Id].[" + UserName () + "] "),
[Measures].[User ID Project Map Count]
)
)
When running the check, I get the following error:
An error occurred in MDX script for the dimension attribute permission's allowed member set: Query (5,9) The member '{User ID Project Map Count]' was not found in the cube when the string, [Measures].[User ID Project Map Count], was parsed.
I attempted a different approach through a different book, which essentially does the same thing using filters in the MDX script, but I get the same error for the measure.
Any ideas why I am getting this error? Help would be greatly appreciated. Thanks.
March 10, 2011 at 10:28 am
Found the problem. In the advanced feature under the Role for dimension security, the window has dimensions at both the Database level and the Cube level. I was attempting to apply the script at the Database level. I discovered a blog where a user was experiencing the identical problem. If you continue to scroll down in the window, there are dimensions at the Cube level. Applying the script at this level works.
Beware. There are dimensions at the Database level and at the Cube level. MDX scripts to dynamically apply security via users must be done at the CUBE level.
Good luck and happy cubing.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply