I am trying to find a way to find all organizational values within a particular cube or data store. For example, data store VCITM contains the objects 0COMP_CODE and 0DISTR_CHAN. Does anyone know of a way to find a listing of the values these objects have within this particular data store.
Note: I need to find this information for security purposes in order to limit certain users to seeing only certain company codes. I want to do this on all infoproviders, but first I need to know what values the providers have within them.