Hi,

I want to use a dynamic security cube.
I'm using this formula:
STRTOSET(IIF(USERNAME="","{}",SETTOSTR(

nonemptycrossjoin([Employees].[Employee Name].members

, {strtomember("Users.[All users].[" + UserName + "]")},
{measures.[Access]},1)

)))

but I received a syntax error when I save the custom dimension security
dalog box because the result of the formula contains a lot of continuous ,
(coma)



Like:

[Employees].[Employee Name].&[Id1], [Employees].[Employee Name].&[Id2],
[Employees].[Employee Name].&[Id3], ,,,,,,,,,

if I execute the same formula without the settostr and strtoset functions
(just the nonemptycrossjoin formula) then the right list is returned to the
user.

what is the problem?

any idea?



thanks.

Jerome.

ok
problem found

its at the employees dimension level, the configuration of the levels is
wrong.

now all works fine!!!

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote