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 my cube.
TIA
Hi,
When you execute the Test Role button, it takes in the Logged in User and
tries to apply the Security MDX on this. (Bascially the UserName function
would return the Logged in User's Information.)
Please check if the Logged in user has got corresponding records in the All
Regions Dimension.
Thanks,
Sanka
"Craig" wrote:
> 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 my cube.
> TIA
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment