Skip to Content
0
Former Member
May 18, 2010 at 08:49 AM

How to hide compounded object values in columns ?

102 Views

Hello Everyone,

I have one MD object called depreciation area which has 3 objects in compounding tab called company code, asset and asset sub number.

When I try to add depreciation area in columns part of Bex query, I see that there are multiple columns comming up for same depr area. This is possibly because there are multiple entries in the SID table for same depreciation area and different combination of company code, asset and asset sub number.

I want to avoid this and only display columns with unique depreciation areas i.e one column for each depreciation area.

I am using BI 7.0.

Can anyone help me with this.

Thanks,

Vijay