Restricting Data with Query Filters - consultant SAP

Restricting Data with Query Filters - consultant SAP

1. Query Filter

   • Advantagens of using query filters include the following
     • You can limit data you do not want specific users to see when they acess the document
     • You can retrive and focus only on the data that you need to answer a especific business question
     • you can minimize the data returned to the document, thus improving performance, because the time required to create an refresh the documet over the network is reduced.
   • Applying a Single-Value Query Filter
     • Note:
       • Note: Int is also possible to create a single-value filter in a query by using the quick filter button in the upper-right  corner of the Result Objects panel. The quick Filter is useful only if the object that you are filtering on appears in the Result Object panel. To use quick filter, you first have to chose the object that you want to filter on in the result Object panel and the choose quick filter. The list of values of the object will po up so that you can make the selection of the values to filter on. If your object does not have a list of values. The quick filter button grays out.
   • Filter Data Using Single and Multi_value Query filter
     • Note:
       •  When the query filters panel does not apper, in the query panel tooobar, choose filters panel.
       • You need to change the filter operator. THE EQUAL TO OPERATOR RETURNS ONLY A SINGLE VALUE.
   • Using Wildcards in query filters
     • When you create a query filters using a wildcards, you must use one of the following relational operator.
       • Matches Pattern
         • ton find values that match the pattern you specify
       • Different form pattern
         • To  find values different from the pattern you specify
     • Wildcards : % Any number of unspecified charcters
       • SM%: Returns all the names taht start with SM
     • Wildcards: __ A single unspecifield charcter
       • SM_TH: Names that start with SM, end with TH, and have a single, unspecifield charcter between the dow-consonant sets
   • Prompts