0

Filtering on multiple conditions

I have created a table of finance transactions, and filtered on about a dozen G/L accounts using the 'in list' operator with | between the accounts. I am needing at add an additional filter on the field 'Closing Entry'. I had already deployed the filter on the account numbers and this was working fine…
So in the data selection i selected 'closing entry' and the operator not equal and in the value field I entered 1….. It does not seem that both filers are sticking, when i redeployed my cube all the accounts were returning (but the closing entry values did not return) in SQL it would be the equivalent to

Select * from
FinanceTransactions where
GLAccountNo. in (1,2,3,4,5,6,7,8)
and ClosingEntry<>1

How do i get the Data selection wizard to understand the 'and' operator when filtering on multiple conditions?

1 comment

Please sign in to leave a comment.