cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Issue Query

Former Member
0 Kudos

Hello, I have a query regarding BEX. I have a same requirement like this thread:

http://scn.sap.com/thread/2054781

material   plant   ordqty

A              p1        100

A              p2         50

B              p1         30 

I want a new keyfigure to show

material      plant   ordqty     ordqty(all plant)

A                  p1       100          150

A                  p2        50            150

B                  p1        30             30

I tried to follow what this was person did and success. but in my case it did not work. I did what Anindya told this person to do but SUMCT, GT or RT are not wokring at all. did i miss something?

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

anshu_lilhori
Active Contributor
0 Kudos

Try like this :

Switch on the result row display for Material..Then create a new formula and put ordqty using the function SUMCT.

Regards,

AL

Former Member
0 Kudos

Thank you for your feedback. I have tried all these things but still not getting the results. I have tried using the ref. char. for Plant as well as Material but nothing worked. I have my result rows on also for both characteristics. see mine is not exactly material and plant mine is Material and Vendor but requirement is still the same

Material     Vendor     Quantity

A               10023          10

A               10023          15

B               10041          100

I want this:

Material     Vendor     Quantity    New column

A               10023          10               25

A               10023          15               25

B               10041          100              100

Thanks.

anshu_lilhori
Active Contributor
0 Kudos

Please check the data properly:

How come you have same material and vendor combination in two different rows.Isn't that should get aggregated.

Check this help.sap link.

Data Functions (SAP Library - Business Intelligence)

Regards,

AL

former_member182470
Active Contributor
0 Kudos

Hi Venkat,

Your ideal report should be like below:-

Former Member
0 Kudos

Oh no AL. sorry. i copy pasted here is the correct one:

Material     Vendor     Quantity

A               10023          10

A               10090          15

B               10041          100

I want this:

Material     Vendor     Quantity    New column

A               10023          10               25

A               10090          15               25

B               10041          100              100

Thanks

Former Member
0 Kudos


Suman, yes this is what i want exactly sir.

former_member182470
Active Contributor
0 Kudos

Then you might have not set the result rows property for Material and Vendor in Rows properly. Please try that, you will get it easily. Use Result rows "Always Display" for both chars in rows pane in query.

anshu_lilhori
Active Contributor
0 Kudos

I do not understand that why SUMCT is not working in your case.Make sure to switch on the result row display for the characteristic in rows.

Alternative approach:

Assuming you have Material and vendor in rows:

Make a copy of Quantity Kf--Drag and drop vendors from left hand side--Right click on it and apply constant selection.

This way also you will get the desired result.Tested on my system working perfectly.

Regards,

AL

Answers (2)

Answers (2)

former_member182470
Active Contributor
0 Kudos

Hi Venkat,

Your requirement is exactly like that thread. I feel you might have done some thing wrong in creating Formula(aggregation tab). You should select Plant as ref char.

I think you are expecting other plants also other than P1 and P2 in new KF. Am I right? That's why SUMCT is not working for you. SUMCT or any data function can only work with the data which is available in the report only. It cannot fetch from BW system separately.

Cross check again and let us know..

Regards,

Suman

former_member976
Active Contributor
0 Kudos

Hi,

create the new formula for the order quantity -> hit the aggregation tab -> exception aggregation -> summation/total -> reference char -> plant.

if you perform the drill down and drill across one char ( material, plant )it will give the values.

Thanks,

Phani.

Former Member
0 Kudos

Phani, I did that but what do you mean by....

"if you perform the drill down and drill across one char ( material, plant )it will give the values."

former_member976
Active Contributor
0 Kudos

Hi,

how your are getting the KF value total while performing the drill down and across it will give the aggregated value for KF

run the same query in RSRT then try.

Thanks,

Phani.