I am trying to create a role on a dimension and when I click on the Test Role button, I get the following error.
"Unable to process one or more commands. User-generated error - the dimension "All Regions" has no valid member. For more information, see your administrator."
Below is the mdx that I have entered on the All Regions dimension of my role.
FILTER(
{[All Regions].[Region Name].Members},
(((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1,128)),[SFAccessre])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1,128)),[Cube Typere])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1,128)),[Dimension Typere])=1)))
I am able to browse the data of the All Regions dimension. The dimensions SFAccessre, Cube Typere and Dimension Typere are all in a Users Region dimension.
I use a similar MDX statement for security on another dimension in the cube.
TIA
"Unable to process one or more commands. User-generated error - the dimension "All Regions" has no valid member. For more information, see your administrator."
Below is the mdx that I have entered on the All Regions dimension of my role.
FILTER(
{[All Regions].[Region Name].Members},
(((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1,128)),[SFAccessre])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1,128)),[Cube Typere])=1)
AND ((STRTOTUPLE(MID(USERNAME,INSTR(1,USERNAME,"\")+1,128)),[Dimension Typere])=1)))
I am able to browse the data of the All Regions dimension. The dimensions SFAccessre, Cube Typere and Dimension Typere are all in a Users Region dimension.
I use a similar MDX statement for security on another dimension in the cube.
TIA