error in dimension

diwaskarki — Tue, 07 Nov 2017 19:26:44 GMT

I am bringing in data from a resident table (SPT_IDENTITY) in the spt_identity4 table and connecting it to spt_audit_event table. When I try to display the attribute from the spt_identity4 table in my list box, I see a red cross mark sign on the dimension in chart properties table. I have attached a picture of the chart properties table.

This is my script:

SPT_IDENTITY:
LOAD ID As IdentID,
NAME As IdentityAlias,
MANAGER As IdentManager,
FIRSTNAME As 'First Name',
LASTNAME As 'Last Name',
EXTENDED6 As IdentExtended6,
EXTENDED7 As IdentExtended7,
EXTENDED10 As IdentExtended10,
InactiveIndicator,
WORKGROUP As IdentWorkgroup
FROM [..\..\QVD\SPT_IDENTITY.qvd] (qvd);

SPT_IDENTITY4:
LOAD IdentityAlias As "AuditAutoFireRequestee",
[First Name] As "Requestee First Name",
[Last Name] As "Requestee Last Name"
RESIDENT SPT_IDENTITY;

//Audit Event
SPT_AUDIT_EVENT:
LOAD ID As AuditID,
MODIFIED As AuditModified,
ACTION As AuditAction,
APPLICATION As AuditApp,
INSTANCE As AuditInstance,
Upper(TARGET & '.' & APPLICATION) As ManagedAttributeAuditKey3,
AuditLCMRequestID,
AuditAutoFireRequestee,
AuditAutoFireRequestID,
AuditAutoFireOffices,
AuditLCMCompletionDate,
date(date(floor(CREATED/1000/60/60/24))+date('1970-01-01')) as LCMCalendarDate,
TARGET As AuditTarget,
TemplateName,
EmailSentTo,
AuditEmailSentSubject,
SOURCE As "Audit Requested By",
TextBetween(ATTRIBUTES, '<entry key="Business Case" value="', '"/>') As "Audit Business Case",
TextBetween(TextBetween(ATTRIBUTES, '<entry key="Approved by RA" value="', '"/>'), '(', ')') As "Audit Approved by RA",
TextBetween(ATTRIBUTES, '<entry key="Completed by (PCU)" value="', '"/>') As "AuditAutoFire Approved by PCU",
TextBetween(ATTRIBUTES, '<entry key="Completed by (DSA)" value="', '"/>') As "AuditAutoFire Approved by DSA",
TextBetween(ATTRIBUTES, '<entry key="Completed by (Manager)" value="', '"/>') As "AuditAutoFire Approved by Manager",
TextBetween(TextBetween(ATTRIBUTES, '<entry key="Approved by Manager" value="', '"/>'), '(', ')') As "Audit Approved by Manager"
//TextBetween(TextBetween(ATTRIBUTES, '<entry key="Requested By" value="', '"/>'), '(', ')') As "Audit Requested By"
FROM [..\..\QVD\SPT_AUDIT_EVENT.qvd] (qvd);

I would really appreciate the help. Thanks

Re: error in dimension

Anonymous — Thu, 09 Nov 2017 16:30:35 GMT

it looks that the fields you re looking for are named "Requestee First Name" and "Requestee Last Name".

maybe the fields "Audit Requestee First Name" and "Audit Requestee Last Name" wer existing fields of a previous version of the app..

topic Re: error in dimension in Connectivity & Data Prep

error in dimension

Re: error in dimension