access filters behave strange
Im trying to set up access filters in a test environment. I loaded the microsoft SQL adventureworks DWH as a datasource.
Then I created an access filter on the product category field. There are 4 categories in the dimension product category. Each of them has sales associated in the internetsalesfact.
First I created a filter where:
- account vincent had 2 categories
- account bram had 2 categories
This gave me no results for the admin. But strange results for the 2 accounts. Account vincent had access to 3 categories whereas account bram had access to 1
Also I find the documentation with regard to access filters a bit lacking. The demo where you actually set up a filter with demo data is from 7.0 and since some aspects have changed. Also, the actual view settings that need to be adjusted are not extensively explained in the wiki.