Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Name | Permission | Level |
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 | Tasks | Full |
Sales Administrator | Team Selling Contribution | Full |
Sales Administrator | Track Messages | Edit |
Sales Administrator | Unbilled Receivable Registers | View |
Sales Administrator | Units | 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 |
John has created some samples for this some time ago, e.g.
How to compare 2 tables and put non-matching results?
Hope this helps,
Stefan