Skip to Content
author's profile photo Former Member
Former Member

'Selection' in the Query Designer

Hello Experts,

Can someone tell me the use of Selection in the query designer. Just a small example : we have 'number of bales' as the key figure, 'bale flags' as the characteristic, now we need to define a formula for '% flag free' which is given as 'bales with no flags'/number of bales * 100. There is no 'bales with no flags' either in the key fig or the characteristic. Incase i define it in the selection part choosing number of bales and bale flags, how does SAP understand the logic that 'bales with no flags'= number of bales-bale flags or is there some other explanation for this.

Any kind of light on this issue would be of great help.

Thanks ahead,

Anjali

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 10, 2004 at 07:15 AM

    Hi,

    assuming in the characteristic bales_flag you have the following values

    ' ' (no flag , might be displayed as # (unassigned))

    'X' (Bales flag X)

    'Y' (Bales flag Y)

    Now when you restrict your keyfigure number of bales with the characteristic value bales_flag ' ' then a selection on all those records will be done where bales_flag is ' '.

    Heike

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Heike,

      Thanks for your response but would you be little bit more clear - am i supposed to create a selection 'bales with no flags' with one key figure 'number of bales' and one restricted characteristic 'bale flags' and then use that in the formula '% flag free'. Am I correct in understanding your solution. Please let me know if i am wrong. When restricting should i choose SINGLE Value or Value RANGE.

      Thanks for your time

      Anjali

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.