Business Objects Web Intelligence Filters

If you are attempting to find out why the data showing on your business objects web intelligence document is incorrect, you may want to start by looking at filters. Once you have verified that the query (data provider) is correct and returning the correct result set, the next step is to look at the filters in your document. For instance, look at the web intelligence report block below. The query that created this report block included all accounts, but only 1 account is showing in the table.

Web Intelligence Data Block

To understand how to diagnosis a business objects web intelligence document, you need to understand how filters work in web intelligence. Think of filters as a funnel with the top of the funnel allowing the most data through the filter and gradually reducing the data set.

Here is the hierarchy of the funnel:

  1. Data Provider Query Filter
  2. Report Filter
  3. Section Filter
  4. Block Filter
  5. Individual Cell Formulas

To visualize the filters, web intelligence provides a document structure and filters panel that shows the filters applied to your document.

Here is the document structure and filters panel that produced the report data block above:

Web Intelligence Filters

You can see that the document is filtered for:

  • account level 2 equal to expense at the report level
  • account level 3 equal to personal service at the section level
  • account level 4 equal to benefit at the vertical table block level

Another way that data is filtered in a web intelligence document is with input controls.

View the input control below:

Web Intelligence Input Controls

This input control produced the filter shaded in gray above (account level 1 equal to use of funds). Input controls can be setup to filter reports, sections, and data blocks.

I hope this helps you unravel the mysteries of business objects web intelligence filters. Please leave a comment with any comments or tips you may have.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.