Artificial Intelligence - Web Intelligence

Back to Course

Lesson Description

Lession - #1077 SAP Webi-Query Filters

Query filters are utilized to restrict the rows returned in a Webi report. Query filters permit you to conceal the information that you would rather not show to explicit individuals and furthermore limit the size of .wid report. At the point when you run an query, it just returns the lines that meet the query filter definition.

Following are the key elements utilized in Query filter −

  • You can recover information according to explicit business necessity.
  • You can hide the information that you don't believe explicit clients should find in a Webi record.
  • Limit the size of Webi document of the network and consequently gives execution improvement.

    Example − Being an Area Sales Manager for NY, you need to see the margin values for your region. sales universe contains information from every one of the region in United States. Likewise you just need to see information from the stores in NY where the business margin is more prominent than 100K USD in the subsequent Quarter (Q2>

    Presently to make a Webi record with this data, you need to apply filters on these aspects - State, Year, and Quarter and Filter on sales margin.

    Filter Operator AND Filter condition: Year = 2015,Quarter = Q2,State = NY,Sales Margin >= 100000

    Difference between Query Filters and Report Filters

    Query filters are applied in Query Panel and they are utilized to restrict the quantity of rows from information sources and to return a similar in the report.

    Report filters are applied at the report level on reports, tables, charts, and so forth. These filters are not used to restrict the information recovery from the information source and just hide specific qualities at the report level.

    Query Filter Structure

    Query filter is applied in this format −

    Object (On which filter is applied>
    , Operator (You can use various comparison operators>
    , and Operand.

    Operand − You can choose from the accompanying list of Operands −
  • Constant
  • List of Values (LOVs>
  • Prompt
  • Universe Object
  • Result from Other Query

    Operators − You can choose from the accompanying Operators −
  • Equal to (=>
  • Not Equal to
  • Greater than
  • Less than
  • Greater than Equal to
  • Less than Equal to
  • Between

    Web Intelligence Consortium (WIC>
    is an international, non-profit organization dedicated to advancing world-wide scientific research and industrial development in the field of Web Intelligence (WI>

    business objects xi web intelligence
    Use the web intelligence Matches pattern operator to retrieve data that includes a specific string or part of a string.