Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to restrict a user to see the data from only one company, CIC, using data reduction. All of our columns are qualified. However, when I try the code below, it doesn't work. I have set "Initial Data Reduction Based on Section Access" and "Strict Exclusion". I also can't seem to find an example of a Section Access using qualified field names.
Can anyone please help? Thanks.
Section Access;
LOAD * INLINE [
ACCESS, USERID, ProductPlan.COMPANY
admin, qlikadmin, *
user, user01, CIC
];
Section Application;
I'd rather avoid using qualified field name for data reduction, but there was another problem with your original section access. Filed name used for data reduction must have name in ALL CAPS, not just the data. You've obviously fixed this problem by using field name DATA_REDUCTION_COMPANY.
Have you tried with a UPPER case table name?
Yes, I have tried using upper case table names but it didn't work either. In the end, I just created an unqualified column DATA_REDUCTION_COMPANY and used that instead for data reduction.
I'd rather avoid using qualified field name for data reduction, but there was another problem with your original section access. Filed name used for data reduction must have name in ALL CAPS, not just the data. You've obviously fixed this problem by using field name DATA_REDUCTION_COMPANY.