cancel
Showing results for 
Search instead for 
Did you mean: 

Display Org Values within a Cube or ODS

Former Member
0 Kudos
47

Hello,

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.

Thanks,

Brian

Accepted Solutions (1)

Accepted Solutions (1)

former_member188975
Active Contributor
0 Kudos

Hi Brian,

You can do that by either running a simple BEx report with just these chars. Or also in LISTCUBE transaction. Use DB aggregation and just select the 0COMP_CODE char for output.

Using an APD you can also find out info about how many records you have that have 0COMP_CODE as say 1202...

Hope this helps...

Answers (0)