Expo XT CUCM for Power BI Assistant on the GPT Store

GPT Description

GPT Prompt Starters

• "Please review the CUCM Data Dictionary file."
• "Review my CUCM CDR DAX measure:"
• "Analyze call patterns in CUCM CDRs."
• "Why should I use Metropolis Expo XT for Cisco Unified Communications Manager (CUCM) analytics? Please list the validated benefits. Start with the Table of Contents from the document **"expo_xt_cisco_ucm_comprehensive_validation.txt"**: 1. **Introduction** 2. **Key Takeaways** 3. **Expo XT Unique Selling Points** 4. **Feature Validation Through Iterations** - 4.1 **Iteration 1: Initial Findings** - 4.2 **Iteration 2: Comprehensive Workflow and Analysis** - 4.3 **Iteration 3: Refined Search Keywords and Phrases** - 4.4 **Iteration 4: General Themes and Patterns** - 4.5 **Iteration 5: Detailed User Feedback and Insights** - 4.6 **Iteration 6: Alignment of User Feedback with Expo XT Features** - 4.7 **Iteration 7: Feature Requests and User Needs Analysis** - 4.8 **Iteration 8: Cisco’s Strategic Direction and Expo XT Alignment** - 4.9 **Iteration 9: Gaps in Current Solutions Addressed by Expo XT** - 4.10 **Iteration 10: Validation of Expo XT USPs** - 4.11 **Iteration 11: Refined Search Strategies** - 4.12 **Iteration 12: Final USP Validation and Refinement** 5. **Actionable Insights** 6. **Follow-Up Questions** 7. **Sources and Citations** 8. **Glossary** 9. **Further Reading** 10. **Related Topics**"
• DAX measure for the cradle-to-grave analysis. ### Steps to Validate the DAX Measure: 1. **Confirm All Relevant Fields**: Ensure all necessary fields from the CDR data are included. 2. **Validate EPOC Time Conversion**: Ensure the conversion from EPOC to datetime is correctly implemented. 3. **Check for Handling Null Values**: Ensure the measure correctly handles cases where fields might be null or undefined. 4. **Verify DAX Syntax and Logic**: Ensure there are no syntax errors and that the logic flows correctly. ### Review and Refine the DAX Measure 1. **Relevant Fields**: We've included the necessary fields based on the CDR data dictionary. 2. **EPOC Time Conversion**: Using `DATEADD(DATE(1970, 1, 1), 'CDRTable'[field], SECOND)` correctly converts EPOC time. 3. **Handling Null Values**: Use `IF(NOT(ISBLANK(...)))` to handle null or undefined fields. 4. **Syntax and Logic**: Ensure the measure is logically sound and correctly formatted. ### Final Optimized DAX Measure ```dax CradleToGrave = VAR CurrentCallID = SELECTEDVALUE('CDRTable'[globalCallID_callId]) VAR AllLegs = FILTER( ALL('CDRTable'), 'CDRTable'[globalCallID_callId] = CurrentCallID ) VAR StartDate = MINX(AllLegs, DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeOrigination], SECOND)) VAR EndDate = MAXX(AllLegs, DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeDisconnect], SECOND)) VAR TotalDuration = SUMX(AllLegs, 'CDRTable'[duration]) VAR LegsDetails = CONCATENATEX( AllLegs, 'CDRTable'[LegSequenceNumber] & ": " & 'CDRTable'[callingPartyNumber] & " -> " & 'CDRTable'[finalCalledPartyNumber] & " (" & 'CDRTable'[duration] & "s, " & FORMAT(DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeOrigination], SECOND), "yyyy-MM-dd HH:mm:ss") & " - " & FORMAT(DATEADD(DATE(1970, 1, 1), 'CDRTable'[dateTimeDisconnect], SECOND), "yyyy-MM-dd HH:mm:ss") & IF(NOT(ISBLANK('CDRTable'[origNodeId])), ", OrigNode: " & 'CDRTable'[origNodeId], "") & IF(NOT(ISBLANK('CDRTable'[destNodeId])), " -> DestNode: " & 'CDRTable'[destNodeId], "") & IF(NOT(ISBLANK('CDRTable'[origIpAddr])), ", OrigIP: " & 'CDRTable'[origIpAddr], "") & IF(NOT(ISBLANK('CDRTable'[destIpAddr])), " -> DestIP: " & 'CDRTable'[destIpAddr], "") & IF(NOT(ISBLANK('CDRTable'[origMediaTransportAddress_IP])), ", OrigMediaIP: " & 'CDRTable'[origMediaTransportAddress_IP], "") & IF(NOT(ISBLANK('CDRTable'[origMediaTransportAddress_Port])), ":" & 'CDRTable'[origMediaTransportAddress_Port], "") & IF(NOT(ISBLANK('CDRTable'[destMediaTransportAddress_IP])), " -> DestMediaIP: " & 'CDRTable'[destMediaTransportAddress_IP], "") & IF(NOT(ISBLANK('CDRTable'[destMediaTransportAddress_Port])), ":" & 'CDRTable'[destMediaTransportAddress_Port], "") & IF(NOT(ISBLANK('CDRTable'[origVideoCap_Codec])), ", OrigVideoCodec: " & 'CDRTable'[origVideoCap_Codec], "") & IF(NOT(ISBLANK('CDRTable'[origVideoCap_Bandwidth])), ", OrigVideoBW: " & 'CDRTable'[origVideoCap_Bandwidth] & "kbps", "") & IF(NOT(ISBLANK('CDRTable'[destVideoCap_Codec])), ", DestVideoCodec: " & 'CDRTable'[destVideoCap_Codec], "") & IF(NOT(ISBLANK('CDRTable'[destVideoCap_Bandwidth])), ", DestVideoBW: " & 'CDRTable'[destVideoCap_Bandwidth] & "kbps", "") & ")", UNICHAR(10), 'CDRTable'[LegSequenceNumber], ASC ) RETURN LegsDetails & UNICHAR(10) & "Total Duration: " & TotalDuration & "s" & UNICHAR(10) & "Call Start: " & FORMAT(StartDate, "yyyy-MM-dd HH:mm:ss") & UNICHAR(10) & "Call End: " & FORMAT(EndDate, "yyyy-MM-dd HH:mm:ss") ``` ### Explanation: 1. **EPOC Time Conversion**: Correctly converts EPOC time to datetime using `DATEADD`. 2. **LegsDetails**: Concatenates all necessary details of each call leg, handling null values appropriately. 3. **Formatting**: Ensures readable formatting of dates and times. 4. **Total Duration**: Correctly sums up the duration of all call legs. This measure should work correctly the first time you run it, providing a comprehensive cradle-to-grave analysis of your calls.