role of conditions in bo

							Module 4
 Conditions
Understanding Conditions
   You can restrict a query so that it returns data related
    to a subset of values for an object rather than all
    values.
   Let’s examine the condition:
      Store Equal to e-Fashion Austin Magnolia.




2 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Understanding Conditions (continued)
   A condition has three elements. These are (for
    example):              Store Equal to e-Fashion Austin Magnolia

                           object
    Condition              operator
                           operand

    These three elements are defined as follows:
         Object :            a field or column of data
         Operator : specification of the relationship between the
                     object and the operand
         Operand : the object value to be searched for

3 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Types of Conditions


   There are four types of conditions that you can use in
    BusinessObjects:
         Single- and multi-value conditions
         Prompted condition
         Multiple condition
         Predefined condition




4 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Single-Value Conditions

   With a single-value condition, you limit data returned
    from a single result object.
   For example, you need to produce a report showing
    Sales revenue for all stores in 1999.




5 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Single-Value Conditions (cont.)




6 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Single-Value Conditions (cont.)




7 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Single-Value Conditions (cont.)




8 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Multi-Value Conditions


   In the previous example, you could only select one
    value (a single year) for the condition. What about
    using several values?
   For example, you need to produce a report showing
    Sales revenue for the states California, Florida, and
    Texas.
   To select multiple values, the procedure is much the
    same as before, except you use a different operator.



9 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Multi-Value Conditions (cont.)




10 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Multi-Value Conditions (cont.)




11 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Applying Prompted Conditions


   When you use a prompted query condition,
    BusinessObjects asks you to choose which data to
    retrieve before running the query.
   For example, you need to produce a report showing
    Sales revenue for all stores based on a year that the
    user specifies when running the query.




12 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
  Applying Prompted Conditions (continued)




                                                                                           Which year?




                                                                    Type the question:
                                                                    Which year?
2000                                                                Then year: 2000
                                                                  Type thepress Enter or click
                                                                    outside Enter or
                                                                  Then press this box. click OK.

  13 Copyright © 1999 Business Objects SA - All Rights Reserved       Issue 1, July 1999
Applying Prompted Conditions (continued)




14 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Understanding Wildcards in Conditions


   Sometimes you may want to search for partial values.
   You can search for any single character or any
    number of characters. In BusinessObjects, you use
    the following wildcards:
      _ = any single character
      % = any number of characters (including none)

   For example, you need to display the Sales revenue
    for all product categories beginning with the letter
    “B.”


15 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Understanding Wildcards in Conditions




                                                                                            B%




                                                                Type the pattern: B%
                                                                Then press Enter or click outside the box.

16 Copyright © 1999 Business Objects SA - All Rights Reserved        Issue 1, July 1999
Using Relational Operators in Conditions
   Relational operators determine the type of comparison to be made
    between two values in conditional expressions or between a value
    and a set of values.
   Relational operators are usually expressed as symbols. However, in
    BusinessObjects they are represented as follows.
        Symbol         BusinessObjects Equivalent
        =              Equal to
        <>             Not equal to

        >              Greater than

        >=             Greater than or equal to

        <              Less than

        <=             Less than or equal to



17 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Using Relational Operators (continued)


   Relational operators are mostly used with numeric data and
    often with dates.
   For example, create a query that displays a product category
    when its Sales revenue is over 1,000,000.




18 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
 Using Relational Operators (continued)




Drag and drop
                                                                                             1000000
to delete




                                                                Type the number: 1000000
                                                                Then press Enter or click outside the box.

19 Copyright © 1999 Business Objects SA - All Rights Reserved        Issue 1, July 1999
Using Relational Operators (continued)




20 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Logical Operators for Multiple Conditions
   You may sometimes need to apply more than one
    condition (to produce a report that focuses more
    precisely on certain data).
   When you specify more than one condition in a query,
    the relationship between the conditions must use either
    the AND or the OR operator. These are logical
    operators.
        AND means that both conditions must be met.
        OR means that either one of the conditions must be met.

   The following Venn diagram illustrates these points.


21 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Logical Operators (continued)
   For example, you need to produce a report showing
    that the store e-Fashion Montreal 42nd sold
    Accessories.
                                              Logically:
                                              A AND B                           All Database Rows



                Circle A:                                       Circle B:
                All rows that meet the                          All rows that meet
                condition   …                                   the condition   …

                Store =                                         (Product) Lines =
                e-Fashion Montreal 42nd                         Accessories



                                                                                      Area C: Rows that
                                                                                      meet conditions of
                                                                                      both A as well as B.
                                                                                      Logically: A OR B


22 Copyright © 1999 Business Objects SA - All Rights Reserved         Issue 1, July 1999
Logical Operators (continued)




23 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Logical Operators (continued)


   Display a table showing all the Product Lines that e-
    Fashion Montreal 42nd sells as well as all stores that
    sell Accessories.
   Tip: This requires you to use the OR operator.




24 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Logical Operators (continued)




        Double click the AND operator to change
        it into an OR operator.

25 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Logical Operators (continued)


   When you specify three or more conditions in a
    query, the structure of the logical operators assumes
    a processing priority. You must organize your
    conditions in the appropriate priority for the result
    you need.
   For example, view the Sales revenue for Trousers and
    City Trousers from the store e-Fashion Montreal 42nd.




26 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Logical Operators (continued)




        Double click the AND operator to change it
            Right click the second AND operator to
        into an OR operator.
            display the speedmenu, then shift it right.


27 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
    Logical Operators (continued)

    You need to change
     the query to show
     the Sales revenue
     for all stores that
     sell Trousers, as
     well as the revenue
     for City Trousers
     only from e-Fashion
     Montreal 42nd.


                                                            Right click, then shift it left.
                                                           Right click, then shift it right.
                                                           Double click to change it to OR.

    28 Copyright © 1999 Business Objects SA - All Rights Reserved    Issue 1, July 1999
Logical Operators (continued)




29 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Using Condition Objects


   Predefined conditions use condition objects.
   You can apply one or more predefined conditions
    when you build a query.
   For example, display the Sales revenue by Categories
    for each store and use a condition object to restrict
    the results to T-Shirts only.




30 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Using Condition Objects




31 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Using Condition Objects (continued)




32 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Using Condition Objects (continued)


   You can keep track of the data you have retrieved by
    displaying or printing the contents of your prompt
    along with the report.
   This is especially useful in reports that have no
    column to display the contents of the prompt (unlike
    this table that displays T-Shirts).




33 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Using Condition Objects (continued)



                                                                 Draw a box with the mouse.




34 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999
Review
   During this module, you developed skills in building
    more powerful queries. These queries let you create
    more focused reports. You learned how to restrict
    data using:
         Single- and multi-value conditions
         Prompted conditions
         Wildcards in conditions
         Relational operators in conditions
         Multiple conditions with logical operators
         Predefined condition objects


35 Copyright © 1999 Business Objects SA - All Rights Reserved   Issue 1, July 1999