Following are the key elements utilized in Query filter −
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 −
Operators − You can choose from the accompanying Operators −
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.