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?