difference between drill filters and report filters in Jupiter

[mohamedali_chriki]

Hi,

I am using a smart measure in a BOXI R2 WebI report and I'd like to apply a report filter on some dimensions. I noticed different behaviors depending on whether I used report filter or drill filter. If I use a report filter on a dimension I get an #UNAVAILBLE error code. However, when I used the drill filter it worked fine and I didn't get any error message. It seems that drill filters and report filters are not functionning the same way. Could someone please help me understand the difference between these two filters?

Many thanks in advance,

Mohamed Ali

[Former Member]

Difference between drill filter and report filter:

Report Filter:

You can filter reports to limit the results that are displayed to specific

information that interests you. For example, you can limit the displayed results

to information for a specific customer or a sales period. The data you filter out

remains within the Web Intelligence document; it is simply not displayed in the

report tables or charts. This means you can change or remove report filters in

order to view the hidden values, without modifying the query definition behind

the document. You can apply different filters to different parts of a report. For

example, you can limit the results in the entire report to a specific product line

and then limit results in a table or chart further to focus on results for a

specific region or customer profile.

Drill filter:

When you drill on a dimension or measure value in a table or chart,Web intelligence filters the drilled result by the dimension or measure you drilled on. The filter is applied to all of the results displayed on the drilled report

Filters appear as list boxes in the Drill toolbar. Each list box contains the

values associated with that filter. You select the data displayed in a table or

chart by choosing the appropriate values from the list boxes.

Example:

Filtering drilled reports by different US states

For example, if you drill down on a table cell displaying u201CCalifornia,u201D to

view results for cities in California, Web Intelligence filters the values in

the entire report for California and only displays results for California in

the report.

By changing the value of each filter, you can then see data for other values

on the drilled dimension. For example, you can select Colorado in the filter

on State.

Note: If the drilled report includes dimensions from multiple data providers,

a ToolTip appears when you rest your cursor on the value displayed on the

filter. The ToolTip displays the name of the query and the dimension for the

value.

Now regarding your issue:

Well I would like to suggest that do not use measures when you apply a filter to an aggregated value from your query and further aggregate it within the report.

Webi cannot determine how the filter affects the calculation of smart measure and instead returns the cell error code #UNAVAILABLE.

Do not use smart measures when there is a:

1. Report filter on a dimension that is not in dimensional context

2. Report filter on the formula

3. Formula in the dimensional context of the measure.

You can use Query filter instead.

However for drill filters and for simple filters combined with AND at the first level of drilling,the context takes the related dimension into account.

Also do not use a smart measure when a standard measure works.