Skip to Content
0
Former Member
Sep 11, 2007 at 09:41 PM

BEx analyzer 7.0 - removing row w/ no data

16 Views

I have a query which uses a structure consisting of 3 instances of Profit center restrictions.

Example:

Structure:

P1 = Profit center A1, A2, A3

P2 = Profit center B1, B2, B3

P3 = Profit center C1, C2, C3

I want to see the breakdown of the structure so I define the query as

Structure, Profit Center, Key Figures

However I get rows w/ profit center that don't belong to structure categorization, w/ key figures empty. How do I remove these rows.