Data Reduction in AccessPoint

[#1]

I have a need to publish a document with reduced data for some users and full data for other users.  When i have 'Strict Exclusion' unchecked, all users can see everything in Access Point, but when i check 'Strict Exclusion' the users that should see reduced data are denied access to the document altogether.

Do anyone know what  I should be looking at?

[Bill_Britt]

I think your issue is around

(TRIM(ProfileRegistrationSource)) AS PROSPECT_SOURCE_CODE

If you are trimming it here and not in the PROSPECT_SOURCE_CODE load you will have a miss match. Also, You have another section access load on your Security tab.

Bill

[mphekin12]

Bill,

That is a valid point but if she is reducing by GROUP she shouldn't be getting an Access Denied Error.  That should only cause data association issues, correct?

[mphekin12]

Ashley, can you post a screenshot of a couple lines of data from 'Data Reduction.xlsx'?

[#5]

I tried the TRIM suggestion and there was no difference.

Here is some data from the QVW:

The restricted users should be able to see that last line of data because they have access to PROSPECT_SOURCE_CODE 100341 among some others, but not 100340 or 100342.

I was also wondering if there might be a data type issue.  All of the values I have in the Section Access that the restricted users are allowed to see are numeric, but in the data that field contains some values that are not numeric... would QlikView treat the ones in the Section Access as numeric and not let them match up with the varchar data field?

[Bill_Britt]

Try this, uncomment the below

//DIRECTORY;

//LOAD UPPER(GROUP) AS GROUP,

//     UPPER(TRIM(ProfileRegistrationSource)) AS PROSPECT_SOURCE_CODE

//FROM

//

//(ooxml, embedded labels, table is Data);

Reload and see if everything matches up with the groups like you think it should

Bill

[mphekin12]

I was hoping you could show some data from the 'Data Reduction.xlsx' file.  Can you show some sample data from the NTName, Access and Group fields since we cannot see that information in the sample .qvw you posted?

Thank you!

[#8]

Yes, my special group called 'SYSTANE' appears to be joining to the 5 source codes to which they should have access.

[Bill_Britt]

Ok, in the section access you have the service account as admin and group is blank?

Bill

[#10]

Oh, sorry, I misunderstood your request.

Here is the users table:

And the reduction data:

[#11]

I've just posted below some data from the section access tables.  I'm not sure what you mean by 'Service Account'...