Below is my script where I am bringing in data from two qvd tables to create two tables.
SPT_AUDIT_EVENT: LOAD ID As AuditID, AuditAutoFireRequestee, AuditAutoFireOffices,
Inactive_AutoFire_Users_Report: LOAD SIGNON_ID, OPERATOR_NAME, OFFICE_CODE, LAST_LOGGED_IN_DATE, (Upper(OFFICE_CODE) & '.' & Upper(SIGNON_ID)) As 'Audit Correlation Key', FROM [..\..\QVD\Inactive_AutoFireUsers.qvd](QVD);
"AuditAutoFireRequestee" has same value as "SIGNON_ID" whereas "AuditAutoFireOffices" has the same value as "OFFICE_CODE".
I have two multiboxes in my dashboard named "Access Request Report" and "Inactive_AutoFire_Users". My problem is when I use "Completed_Date" in "Access Request Report" , it brings data but its not brining anything in "Inactive_AutoFire_Users". Below are the image.
I would really appreciate the help. Thanks. Sorry about the image quality. It uploaded like this for some reason.
The table seems to be correlated, information density is 100%. Subset ratio is 96% on "Inactive_AutoFire_Users_Report" table and 4% on the "SPT_AUDIT_EVENT" table.
The concatenated "Audit Correlation Key" looks like this: "2 - North Coast.DQ4G"
I do have several data like "2 - North Coast.DQ4G" that are similar in both the tables.
But the reason I think my table is not correlating properly is , SPT_AUDIT_EVENT table has a field "Completed_Date", which I am trying to use on a table box. Data in both my "SPT_AUDIT_EVENT" and "Inactive_AutoFire_Users" consists of user alias and offices they have requested access for.
I am trying to use the "completed_date" field in a list box which should correlate to fields from "Inactive_AutoFire_Users_Report" table but it is not .(like shown in the pic above) Sorry, if I am being confusing. I will try a different approach if you did not get what I am saying.