cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Structure issue

Former Member
0 Kudos

Hello BW folks ,

I have following issue ,

I have a structure in rows in the BEx designer .

This structure consists of following four areas,

1. Standard Type : when sales doc type = ABC and Item Category = Excluding XYZ.

2. 3 Rd Party : Sales doc type = ABC and Item Category = XYZ.

3. Rush Type : Sales doc type = PQR and no Item category restriction as Standard and 3 rd party.

4.Free Type : Sales Doc type = LMN and no Item category restriction as Standard and 3 rd party.

Now every order falls under only one of the above four areas like Standard, 3 rd part etc.

all are in rows and

we have Sales figure in Column .

For an order the sales figure is displayed correctly in the report .

But the problem is if the Order falls under Standard type then for all other areas like 3 rd party, rush ,free type is shows empty sales figures which is correct as these area's do not have sales figure when order is having standard type.

But the user do not want the Empty rows for Sales for the rest of the areas in which an order do not fall.

for example : if an Order 1234567 is having Sales figure

77888.00 EUR for standrad type then there will be four rows in the report out of which one row for Standard type will show Sales figure 77888.00 EUR correctly but the three additional rows will be empty.

The user do not want to see these empty rows in the report.

In summary the user wants only that row to be displayed in report for which an Order is having Sales figure in column and he do not want the empty rows for other areas.

Best Regards ,

Amol.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Area // Order Number // Sales

1 .Standard Type // 123456 // 77888.000EUR

2 .3 Rd party // 123456 // EMPTY

3 .rush type // 123456 //EMPTY

4 .Free type //123456 // EMPTY

The user do not want the above empty figures for the sales .

Amol

Former Member
0 Kudos

We are having exactly the same problem as you had in this post. Did you manage to solve this problem or does any one know how to solve this issue?

Your inputs will be highly appreciated.

Thanks,

Hassaan

Former Member
0 Kudos

Thanks, the issue has been resolved.You just have to select the Active (All values=0) option in Rows/Columns tab in query properties, it will supress all zero values.

Regards,

Hassaan