I'm trying to work with Dimension Security for multiple dimension, but
i have som problems that maybe someone can help with.

In my exmaple belove i have 2 dimensions.
The security should work as, if a user chose UK, he has only allowed
to se all things for UK (The X's), but if he chose to see KEYBOARD,
then he should see keyboard for everry country to.

MOUSE HARDDISK KEYBOARD MOTHERBOARD
USA XXXXXXXX
FRANCE XXXXXXXX
UK XXXX XXXXXXXX XXXXXXXX XXXXXXXXXXX
DENMARK XXXXXXXX

I have tryed to solve the problem like this, i have 2 cubes, one with
the 2 dimensions, and one permission cube. Then i make a virtual cube,
and give my user roles, to let him see the UK, and KEYBOARD. with my
MDX on the dimensions.

STRTOSET(
IIF(USERNAME="",
"{}",
SETTOSTR(
NONEMPTYCROSSJOIN(
[Geography].[Geography].MEMBERS,
{STRTOMEMBER("[USERS].[All USERS].[" + USERNAME + "]")},1)
)))

AND


STRTOSET(
IIF(USERNAME="",
"{}",
SETTOSTR(
NONEMPTYCROSSJOIN(
[Product].[Product].MEMBERS,
{STRTOMEMBER("[USERS].[All USERS].[" + USERNAME + "]")},1)
)))

But this will only allow me to see the keyboard for only UK, and that
was not the point. I can only see the intersection, but i wanted to
see the Union. Can anybody help with the problem.