RPAS: Spreading with respect to User Permission on dimensions
A user doesn't have permission to access all lower dimensions (i.e. stores) but have access to higher dimensions (region, country).
#My 1st question is, 'Is it possible for a user to have access in higher dimension if he/she doesn't access to all lower dimension in that same hierarchy?'
#My 2nd question is, 'If the answer of my 1st question is YES, then if the user puts some values at higher dimension, will it be spread to all the lower dimensions under that higher dimension or only those lower dimensions on which the user has access?'