Error limiting dimension values -
08-04-2003
, 08:50 PM
Hello - I am using the following MDX to limit the dimension values in
the foodmart database (Dimension security - allow members):
filter([Store].[Store Name].members,sum(filter([emp_table].[Employee
Id].members,[emp_table].[Employee Id].currentmember.properties("Login
Name") = username),[measures].[measure]) <> 0)
I keep getting error that the emp_table is not a valid dimension.
Thanks for your help! |