emma wrote:
okay... let me explain... i have cube that will report financial report in all store in all branch in 1 company let's say it "financial report" and the goal is every branch will get user login to check their financial report and can check financial report in regency,subdistrict,village,store ,
the structure of the cube is
-branch
-regency
-Subdistrict
-village
-store
That seems unlikely. You have have specified no dimension for time, you have specified no dimension for measures (sales, profit, expenses, etc).
emma wrote:how can i recognize which store that registered in that branch,regency,Subdistrict,village? i already try to create user for branch and set security access for all dimension to branch but the result all regency get the same subdistrict and village,and store....the reason why i didn't want to make them in 1 dimension is... that element will dynamic in every month... the store can move ,or be deleted
I'm afraid that this doesn't make a lot of sense. Are you saying that for a given period (that is, ignoring the fact that the stores can move over time),
a single value (profit, sales, whatever) will relate to:
- A single store;
- In a single village;
- In a single sub-district;
- In a single regency;
- In a single branch?
Because if so, all you need to do is put element level security on the Branch dimension. Zero suppression will take care of the rest. In a zero suppressed view a user will see only the combinations which have non-zero values. They may be able to see all of the village, sub-district, etc elements
in the dimension, but the only elements that will be shown
in the view are those which have values relating to the branch(es) that they have access to.