1 Reply Latest reply: Nov 9, 2017 11:30 AM by raffaele di francia RSS

    error in dimension

    Diwas Karki

      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);

      errorcross.png


      I would really appreciate the help. Thanks