Thank you again. Appreciate it.

OK, that makes sense, so Denied wins everytime, and can specifically override inherited privs. But I guess the thing to note is that in MOST CASES I don't need to specifically deny permission to a privilege (if the user or access role is not Granted they wont see it or have the functionality by default). Is that statement…

I figured it out, here was the problem. In the BMM in the RPD I had the Fact measure defined as COUNT(TABLE.COLUMN). Derived from existing columns... When I changed that to Derived from physical mappings and set the aggregation as Count, the functionality now works as expected. Thanks all for responding.

You want to see the Select D1.c... statement from the NQQUERY log or something else? Thanks

Hi Thomas, thanks for responding. It doesn't have the filter condition at all. The syntax appears as if the column is completely vanilla. The syntax is appearing as a simple SELECT Count FROM Fact Table. Just for reference, I'd tried rebuilding the RPD, same problem, and I tried this on a different version and same problem.

Hi All, just wanted to respond. The physical sql DOES NOT look like its picking up the column condition at all. Which is strange because in the Logical SQL its there, but when comparing two physical SQL statements (one that works and this one that doesn't). Can I try to force it in the XML or SQL and see what happens or…

Thank you all for the responses. Going to tackle this issue again next week. Will let you know if I figure it out.

I agree it sounds impossible, that's why I'm here, wondering if I'm missing something very simple.

Hello, Thank you for responding What I mean is, just running number purchased, just the fact measure, without any filter in the column or the report, returns 10,000, for all time periods and locations. Adding NY to the report filter, pairs it down to 500. Trying that filter directly in the column itself using the filter…