Data Reduction AND OR Operations on Multiple Dimensions

Thu, 17 Nov 2011 21:28:46 GMT

Hi there,

I am trying to use data reduction to filter the data corresponding to individual users and my dimensions are not hierarchial. I am able to achieve data reduction on AND & OR operations in isolation. However, if my users list in the Section Access some are AND operation and some are OR operation, the data reduction seems not quite work and I need some help on that.

My section access are as follows:

OR operation

ACCESS, NTNAME, OP, FILTER, COSTFILTER, CATFILTER

ADMIN, ERIC.LAM, OR, PET MANAGEMENT, *, *

ADMIN, ERIC.LAM, OR, DIRECT, *, *

AND operation

ACCESS, NTNAME, OP, FILTER, COSTFILTER, CATFILTER

ADMIN, MAT.LAM, AND, , PET MANAGEMENT, DIRECT

Mixture of AND & OR

ACCESS, NTNAME, OP, FILTER, COSTFILTER, CATFILTER

ADMIN, ERIC.LAM, OR, PET MANAGEMENT, *, *

ADMIN, ERIC.LAM, OR, DIRECT, *, *

ADMIN, MAT.LAM, AND, , PET MANAGEMENT, DIRECT

Many thanks in advance,

Eric.

topic Data Reduction AND OR Operations on Multiple Dimensions in QlikView

Data Reduction AND OR Operations on Multiple Dimensions