...

Artificial Intelligence - Web Intelligence

Back to Course

Lesson Description


Lession - #1084 SAP Webi-Query Filter Types


Following types of query filters are normally used −

  • Predefined Filters
  • Custom Filters
  • Quick Filters
  • Prompts

    Predefined Query Filters

    These filters are regularly Administrators and saved at the Universe level. They are utilized to populate information that is for all time accessible.

    These filters require some great information on data set design and complex expression. Utilizing predefined filters on Universe implies you don't have to make custom filters each time when another Webi report is made.

    Likewise note that you can't get to the parts of Predefined filters and editting them is additionally impractical.

    To add a Predefined filters, you can drag or double-click this filter to Query Panel → Filters Pane.

    At the point when you run the query, comparing information w.r.t filters will be added to the report.

    How to Use a Predefined filter?

    You can use a Predefined filter by a double-click or just by dragging the filter to Query Filter.

    Quick Filters

    Quick filters are utilized to quickly recover the qualities you need without the utilization of filter editor. Quick filters ls utilize equivalent to administrator while involving a solitary value or list in administrator when you utilize numerous values.

    How to Use a Quick Filter?

    Quick filters are utilized in Query panel. To apply a Quick Filter, select the item you need to filter.

    Select 'Add Quick Filter' at the upper right corner of Result Object Pane.

    New dialog box will open. You need to choose the value you need to use in the Quick filter from LOVs.

    That filter will be added Query Filters sheet. To erase this filter, select the filter in Query filter sheet and press 'delete' button.

    Custom Query Filters

    You can likewise make custom query filters to meet the business necessity or to hide the information from explicit clients.

    To make custom query filter, add the object you need to use in the filter. Drag it to Query filter pane. Click the arrow next to default administrator and select the administrator.

    Click on the arrow to select the filter type.

    You can choose the following filter type −

  • Constant
  • Value from list
  • Prompt
  • Object from this query
  • Result from another query

    Select the value from this that you need to remember for the filter. To eliminate a filter, select the filter and press 'Delete' button. To eliminate all the filter, use 'Delete All' choice at the upper right corner of the screen.

    Prompts

    Prompt is characterized as a unique filter for clients, which permits them to enter a value each time information is revived in the report.

    Utilizing prompts, you have various clients viewing one archive to show different sub set of information in data set. Prompts permit you to recover the information from data set and lessen the time.

    Merged Prompts

    At the point when you utilize various information providers in a solitary record, you can merge numerous prompts with same information type, same administrator types and same brief text are combined. While reviving every one of the information providers, one brief shows up for every one of numerous prompts.

    LOVs showed by merged prompt is the list related with the item in prompt with the most shown property imperatives.

    Building Prompts

    To build a prompt, add the item you need to filter with a prompt to Query Filter sheet.

    Select the filter administrator from the list and snap on the last arrow imprint to choose a prompt.

    You can add the text message for Prompt value and run the query.

    At the point when you run the query, Prompt dialog box will permit you to enter the qualities according to the chose administrator.

    At the point when the qualities are chosen and you click 'ok', and the information for chose values in the archive will be reflected.

    Deleting a Prompt

    To delete a prompt , select the prompt in Query filter sheet and press the 'Delete' button. You can likewise choose Remove or Remove all choice.

    hacking web intelligence
    web intelligence vs crystal reports:Crystal Reports is best for highly structured reports, while Web Intelligence is most suitable for 'unstructured' reports