Setting Up Security on Dlist formatted Items

[bk1639]

Hi,

I'm looking for a way of setting up security on a dlist formatted item. If I don't explain myself correctly, please don't hesitate to ask me to clarify my question.

Following are the Dlists in my cube

Geography
City
Property

In the above elists, i am using Geography as Context(u can call it as Pages also)
and City & Property as formatted Dlists in the KPI's dlist.When the user selects Geography as North,then the corresponding Cities will appear in the drop downlist of City in KPI.This i have done by using access tables by creating different foratted elist items in KPI's elist(City-North,City-East,City-South etc).

But i am having problem to set up security on Property item.When user selects the coresponding City in the KPI's dlist,then i have to show the coresponding properties of that city only in the City formatted item.How i can achieve this?

Can i anyone suggest?