Dimension has a generated security expression that is not valid for parent-child dimension
I am trying to set security for a parent child dimension and getting the following error while trying to test the dimension security in Visual Studio.
Unexpected Error: the 'Account' attirbute in the 'Account Dim' dimension has a generated security expression that is not valid.
The error occurs while trying to test role based security through Visual Studio. I have set and test role based security on a regular dimension by setting a restructed member.
The generated MDX for the Denied Member set is
{[ACCOUNT DIM].[Account].&[11000], [ACCOUNT DIM].[Account].&[12000], [ACCOUNT DIM].[Account].&[13000], [ACCOUNT DIM].[Account].&[14000]}
Has anyone come across this one? I am using SQL2005 EE(x64) SP1 (SSAS version 9.00.2047.00).
Once I remove the denied members, the role works as expected.
