Ignoring Compounded InfoObjects in BEx Query

pts.
Tags:
Business Information Warehouse
I need to produce an SAP BW report on labor hours and quantity by 0OPERATION only; however, 0OPERATION is compounded to 0PRODORDER. The typical query will always add the 0PRODORDER value to the front of the 0OPERATION value, so that the common 0OPERATION values are not condensed into a single row. This is great for most of our reporting needs, but this one report wants to ignore the 0PRODORDER value. How can I make this report ignore Order and only report on Operation?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you really sure you want to ignore the order number?
If you do this, and you select operation 1 in your query, you will get the values for both operation 1 of order 1 and operation 1 of order 2.

You should not be doing this unless you have some other method of ensuring that your operation numbers are unique.

If you really do want to do this, you can drag the order out of the query definition.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following