Is it possible to set a dimension data rule for a role that will filter dimension members dynamically such that only members relating to at least one fact record will be shown? In particular, the rule should be applied after all other filters
on the fact data for the user have been taken into account.
This situation is there is a single client dimension but users should not be able to see the client information (e.g. name, address) unless it is related to a fact that the user has access to.
View Complete Post