Error using filter on database role

[craig322]

I am trying to use a virtual cube to link two physical cubes. One of my real cubes is a fact cube and the other is a security cube. I have created an MDX statement to link the two based on the userid (which is a field in the security cube). When I run a sample query using this filter in the mdx app that ships with analysis services, I get the desired results. When I try to use the filter in a role on the dimension for my filter, I receive an error message that says Unable to update role in cube. I can't access the cube then. If I remove the role, I have no problems. Here is my MDX statement.

FILTER(
{[Organization].[Outside Sales Name].Members},
((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\&quot+1,128)),[SFAccess])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\&quot+1,128)),[Cube Type])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\&quot+1,128)),[Dimension Type])=1))