Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error - Dimension has no valid member

Status
Not open for further replies.

craig322

MIS
Apr 19, 2001
108
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top