You can configure a SQL fact table filter expression like:

"Fact_Table"."Closed_Claim" <> 0


From SQL BOL>>

Filter Tab (Drillthrough Options Dialog Box)

Use this tab to specify a filter (WHERE clause expression of an SQL
SELECT statement) to limit the result set returned by drillthrough. Type
the text that follows WHERE, but exclude the WHERE keyword.

For example, to limit the result set to 1998 data, type:

"the_year"=1998

Another example (alphanumeric data):

"the_month"='January'

Whenever necessary to avoid ambiguity, use a qualified expression. For
example, if a column name appears in multiple tables, include the table
name in the expression:

"time"."the_month"='January'

The SELECT statement used to retrieve rows for the creation of the
result set is generated automatically. The filter expression is
connected with an AND to the automatically generated part of the WHERE
clause. Therefore, if you specify multiple filter expressions, enclose
them all in a pair of parentheses, for example:

("the_year"=1998 OR "the_year"=1999)

The filter expression acts as a pass-through statement, and its syntax
is not checked until a drillthrough is executed. If the syntax is
incorrect, drillthrough fails.

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Deepak

I was reading the books online, and saw the Drillthrough Options Dialog Box. Wouldn't that filter apply to absolutely every drill through that happened? Depending on which measure I'm drilling in on, I'd like to filter out the zeros for that particular measure. There are over a dozen measures in the table

Thanks
Victor

Victor,

Based on your post, I thought that you were looking to filter out 0's
for that particular measure. Drillthrough results from a single physical
cube are the same, no matter which measure is selected.

I don't know the details of your multiple measures; but in cases where
the fact table field for a measure only takes on a finite set of values
(such as 0 or 1), it may be advantageous to create a simple dimension,
from which the desired measure (say, OpenClaims) can then be calculated
by selecting the appropriate dimension member (say Open). This will
allow drill-through to only the rows you want.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!