Hi, i'm new with as so i think this could be a a stupid question but
i've not yet find an answer:

i've a fact table with 3 dimension (time, delivery, sales), i create a
role with dimension data security on delivery
if i browse the cube using that role and i put time on x axis and
delivery on y axis dimension security work fine.
but if i put sales on y axis i see everythings. I would see only sales
data related to delivery dimension.

example:
FACT:
year   Delivery   Sales  measureA
2011     USA       A         100
2011     USA       B         50
2011      EN        A         100
2011      EN        C         200

ROLE1 can see only USA in delivery dimension

browse DELIVERY /YEAR
                         2011
USA                   150

if i browse sales/year i see this:
            2011
A           200
B            50
C           200

instead i'd like to see
           2011
A          100
B            50

How can i attempt this?