Negative project totals query in BW reporting

Negative project totals query in 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?

    Requires Free Membership to View

    Login

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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 first published in December 2006