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.
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:
- Data Provider Query Filter
- Report Filter
- Section Filter
- Block Filter
- 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:
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:
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.