I am analyzing the changes in user permissions in a single system from two points in time: today and one year ago.
Both data sets have the same 3 columns: Name (user role), Permission, and Level (read, write, edit). I have loaded to prevent syn keys.
1. There were changes in the available Names (role). Some appear one year ago and not today, while some appear today but not a year ago. This is easy for me to analyze and I already have the delta.
2. Some Names (roles) have different permissions, and perhaps even different levels between the two time periods. This is the hard part. How an I show the differences in a QlikView--either using flags or colors or some other method? Alternate States?
E.g., AP Manager today has "Accounts Payable Graphing" permissions, but did not 1 year ago.
Below is a sample of the data set, to a data set of about 80k rows. Thanks
|AP Accountant - Bel||Account Detail||View|
|AP Accountant - Bel||Accounts||View|
|AP Accountant - Bel||Accounts Payable||View|
|AP Accountant - Bel||Accounts Payable Graphing||View|
|AP Accountant - Bel||Accounts Payable Register||View|
|AP Accountant - Bel||Accounts Receivable Register||View|
|AP Accountant - Bel||Allocation Schedules||Edit|
|Sales Administrator||Team Selling Contribution||Full|
|Sales Administrator||Track Messages||Edit|
|Sales Administrator||Unbilled Receivable Registers||View|
|Sales Administrator||Upsell Assistant||Full|
|Sales Administrator||Upsell Setup||Full|
|Sales Administrator||Upsell Wizard||Full|
|Sales Administrator||Web Services||Full|
|Sales Administrator||Work Calendar||View|
|Sales Administrator - SAML||Accounts Payable Register||View|
|Sales Administrator - SAML||Accounts Receivable||View|
|Sales Administrator - SAML||Accounts Receivable Register||View|
|Sales Administrator - SAML||Bank Account Registers||View|
|Sales Administrator - SAML||Calendar||Edit|
|Sales Administrator - SAML||Companies||Full|
|Sales Administrator - SAML||Competitors||Full|
|Sales Administrator - SAML||Contact Roles||Full|
|Sales Administrator - SAML||Contacts||Full|
|Sales Administrator - SAML||Contract||Full|
|Sales Administrator - SAML||Contract Item||Full|