TCD reporting

Version 1
    This document was generated from CDN thread

    Created by: Sarah Barnes on 02-05-2013 09:51:51 AM
    I have created a TCD report which brings back data if I set the Key Criteria field in properties as ANI, however if I change it to Skill Group, then it doesn't bring back any data at all.
    As far as I can see everything is associated correctly and when I run it with ANI I can see the Skill Group information, therefore I don't know where to look!
    Any help or advise will be greatly appreiated.
    Here is the query.
    SELECT
    DateTime,
    Agent.EnterpriseName as Agent,
    Skill_Group.EnterpriseName as SkillGroup,
    TCD.DigitsDialed,
    TCD.DNIS,
     TCD.ANI,
     TCD.TalkTime,
     TCD.RingTime,
    TCD.TimeToAband,
     TCD.Duration,
     TCD.HoldTime,
    TCD.LocalQTime,
     TCD.WorkTime,
    Agent.SkillTargetID
    FROM
    Termination_Call_Detail TCD
    JOIN Agent ON TCD.AgentSkillTargetID = Agent.SkillTargetID
    JOIN Skill_Group ON TCD.SkillGroupSkillTargetID = Skill_Group.SkillTargetID
     WHERE  Agent.EnterpriseName
    IS NOT NULL ORDER BY Agent.EnterpriseName ASC, DateTime ASC, Skill_Group.EnterpriseName ASC
     

    Subject: AUTO: Gregory Grebin is unavailable (returning 05/06/2013)
    Replied by: GREG GREBIN on 02-05-2013 09:55:07 AM
    I am out of the office until 05/06/2013.

    I am on PTO with limited access to email and phone.



    Note: This is an automated response to your message "New Message from Sarah
    Barnes in Contact Center Reporting (CCR) - Contact Center Reporting: TCD
    reporting" sent on 05/02/2013 09:51:58 AM.

    This is the only notification you will receive while this person is away.


    Prime Therapeutics made the following annotations
    ---------------------------------------------------------------------
    CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender.


    ---------------------------------------------------------------------

    Subject: RE: TCD reporting
    Replied by: Sarah Barnes on 02-05-2013 10:33:57 AM
    Hi Steve, unfortunately that is where my problem is I do not have access to teh SQL Query Analyzer to know why it is not working, so I am sort of running blind.
    However I am pleased to read that you had information come back from my query based on Skill group - so hopefully it will work in the customers environment and it is just our lab syste, :-)

    Subject: RE: TCD reporting
    Replied by: Sarah Barnes on 02-05-2013 10:40:44 AM
    Steve you are brilliant i have added in teh SkillGroupTargetID and it works.. see it is the little things :-)
     
    Thanks

    Subject: RE: TCD reporting
    Replied by: Steven Maas on 02-05-2013 10:18:19 AM
    I copied your query and was able to produce results.
    It may be how CUIC is performing the where clause.
    I would do the following.
    Execute this is CUIC then and select the 'SQL' that CUIC generates.  Then run that directly in SQL Query Analyzer.  Chances it is how CUIC creates the WHERE clause,  

    Subject: RE: TCD reporting
    Replied by: Steven Maas on 02-05-2013 10:23:59 AM
    Additional Thought.
    If you are using the stock Skill Group collection.  The value list needs to be set on SkillGroupSkillTargetID and your Key Criteria Field should be SkillGrouSkillTargetID.