Q
Problem solve Get help with specific problems with your technologies, process and projects.

Negative project totals query in BW reporting

In this expert response, Peter Scott exposes how to query only negative projects in SAP BW reporting.

My query displays net project totals (negative and positive). I would like to view only the negative projects.

My current solution is to use a 'goto', which runs a second query with the condition applied. Is there a way of...

applying a condition with out re-running the query?

Yes, there is a fairly straightforward way of producing the result you are after. Let's say that your negative and positive values are displayed in a column for a key figure called "Project Totals". In the query definition, you can create a new 'Condition for the Project Totals' key figure and apply the 'Less Than' operator with a value of 0. If you ensure that this condition is Active by default (the Active box is checked), you will only see projects with negative totals in the results area.
This was last published in December 2006

Dig Deeper on Business Objects and SAP business intelligence

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close