How to exclude values (if multivalue dimension) from a list

building reports webintelligence
1

Hi,

I have a report that shows people that could have different codes for how we could communicate with them (no mail, yes mail, newsletter, etc.) and I want to exclude the once that have no mail and no e-mail values, even if they have other values included as well.
When I tried a Not Inlist in my query I still got them because of the other values.
On the other hand, when I tried doing an additional query with a list of the ones who have the codes I want excluded in order to exclude them in the second query, it takes foreeeever to respond.
I have tried the exclusion condition to be:

  • person not inlist (values from another query, and I set here the personid list from the first query)
  • subquery that says personid not inlist personid where personid not inlist (values from another query, and I set here the personid list from the first query)

Both ways take so much of a time that I better cancel it.

Any advice will be greatly appreciated.

Thanks in advance,

Brenda

brendaivett (BOB member since 2014-11-12)

2

Hi,

Just wanted to let you know that I found out how to fix this, I guess I was setting up the subquery in a wrong way, what I did now was to insert a subquery in my query with the condition of

personid Not InList PersonId
Where ContactCode InList (List of Codes I want to exclude)

Thanks!

Brenda

brendaivett (BOB member since 2014-11-12)