Voice Reporting DPs and its Use Cases
Updated
DPs | Functionality |
ASSIGNMENT_ENGINE_REPORTING_ENABLED | Enables ACD Reports |
METRIC_FILTER_ENABLED_ENGINES : set , partner level | Helps enable measurments as filters (bot applicable for any measurement, only certain measurments would be enabled) |
REPORTING_PIVOT_CHART_ENABLED | Enabled the Pivot table type of visualisation |
REPORTING_CACHE_DISABLED_REPORTS | Disables cache for the specific backend report name, helps get the data faster in UI |
curl -XPOST -H "Content-type: application/json" 'http://prod0-restricted-tier1.sprinklr.com/restricted/v1/agentPerformance/0/saveOrUpdateMetricConfig?setUpDefaultValues=true' -d '{"userAvailableStatuses":["Available"],"mealBreakStatuses":["Meal Break"],"teaBreakStatuses":["Tea Break"],"miscellaneousBreakStatuses":["Miscellaneous Break"],"notReadyOccurrenceStatuses":["Meal Break","Tea Break","Toilet Break","Miscellaneous Break","Unavailable"],"breakStatuses":["Meal Break","Tea Break","Toilet Break","Miscellaneous Break"]}' | Standard reporting config for any new partner Standard Config For reference - https://sprinklr.atlassian.net/browse/ITOPS-279980 |
OVERRIDE_REPORTING_EXPORT_TIME_AS_HHMMSS | Enables SLA type measurments to come in HHMMSS type format in exports |
USER_LOOKUP_LOGGED_IN_USER_FILTER_ENABLED | Enables logged in user value for user / agent filter - needed widget for self monitoring |
SPRINKLR_VOICE_CHANNEL_ENABLED("sprinklr.voice.channel.enabled", BOOLEAN, PARTNER), | To enable voice care in any partner |
SPR_TASK_USER_PROPERTY_ENABLED | enabled customer properties in spr task report |
REPORTING_AVAILABILITY_SLA_REPORT_ENABLED("reporting.availability.sla.report.enabled", BOOLEAN, PARTNER) | To enable AvialabilitySLA report, should be enabled by default in new partners |
REPORTING_USER_OCCUPANCY_REPORT_ENABLED | To enable Occupancy report, should be enabled by default in new partners |
REPORTING_USER_SLA_REPORT_ENABLED | To enable UserSLA report, should be enabled by default in new partners |
User Occupancy Job | To enable Occupancy job, needed to populate data in occupancy report metrics |
REPORTING_AUTO_REFRESH_DASHBOARD_WIDGET_ENABLED | To enable auto refresh functionality in reporting widgets |
UNIFIED_ANALYTICS_REPORTING_ENGINE to the DP METRIC_FILTER_ENABLED_ENGINES ("METRIC_FILTER_ENABLED_ENGINES value to set --> PAID,LISTENING,STORY_MESSAGE,PLATFORM,PROCESS_ENGINE,VOICE,UNIFIED_ANALYTICS_REPORTING_ENGINE") | METRIC_FILTER_ENABLED_ENGINES value to set --> PAID,LISTENING,STORY_MESSAGE,PLATFORM,PROCESS_ENGINE,VOICE,UNIFIED_ANALYTICS_REPORTING_ENGINE,SPR_TASK |
com.spr.scheduler.jobs.reporting.sla.UserSLAJob | Should be enables by default |
REPORTING_USER_LOGIN_TIME_ENABLED | Should be enables by default |
USER_CUSTOM_PROPERTY_INDEX_ENABLED: Boolean dp | enable user custom proprties in required analytics |
PROCESS_EXECUTION_REPORTING_ENABLED | Enables Process execution analytics report |
DATA_ENGINE_DEFAULT_REPORTING_SOURCE_TABULAR_ENABLED("data.engine.default.reporting.source.tabular.enabled", BOOLEAN, PARTNER), | dataflow query optimisation |
USER_DASHBOARD_FILTERS_ENABLED | Add Support in Reporting for user Contextual Filters for a Scalable Architecture |
CASE_PROPERTIES_SYNC_ENABLED_STORES curl -XGET 'http://prod-restricted-tier1.sprinklr.com/restricted/v1/caseManagement/1089/syncDataInListening?serverTypeCsv=PROCESS_EXECUTION_RECORD,REPORTING&caseCreationTimeSince=1627822762000&caseCreationTimeUntil=1631797162000' | enables to plot case custom properties in required reports Value - Reporting |
CALCULATED_METRIC_FILTER_CACHE_DISABLED_REPORTS_OR_ENGINES VOICE,PLATFORM | To remove caching in custom metric |
REPORTING_EXPORT_SHOW_TOTAL | To enable show total in reporting excel/csv exports |
CUSTOM_ENTITY_REPORTING_ENGINE_VISIBLE_ON_UI | To enable custom entitiy reports |
FIFTEEN_MINUTE_AGG_SUPPORTED_ENGINE | To enable 15 mins aggregation Value - PLATFORM |
REPORTING_ALERTS_ENABLED(“reporting.alerts.enabled”, BOOLEAN, PARTNER) | To enable reporting alerts |
REPORTS_WITH_PROJECTION_DRILLDOWN | Gives the drilldown data only on the clicked value in any type of widget having multiple measurments plotted curl -XPOST -H "Content-Type: application/json" "http://localhost/restricted/v1/rac/core/DynamicPropertiesRAC" -d '{"opName": "upsert-partner-property","partnerId":"200055","propertyName":"REPORTS_WITH_PROJECTION_DRILLDOWN","value":"VOICE,VOICE_AGENT_PERFORMANCE","reason":"enable drilldown for VOICE, VOICE_AGENT_PERFORMANCE - Deepika"}' |
REPORTING_EXPORT_ROWS_LIMIT("reporting.export.rows.limit", LONG, PARTNER), | Helps increase the csv/excel export limit |
VOICE_ASSIGNMENT_REPORTING_BUFFER_DURATION | Backup job DP to define the threshhold to fix the voice data, for example missing call disconnect webhook. Add this in partner 0 Server type SCHEDULER db.coreall_jobs.save({ "_class" : "com.spr.scheduler.v7.SchedulerJobDetails", "jobName" : "com.spr.scheduler.jobs.assignment.AssignmentReportingJob_400032_job", "jobClassName" : "com.spr.scheduler.jobs.assignment.AssignmentReportingJob", "partnerId" : NumberLong(400032), "clientId" : NumberLong(-1), "channelType" : "", "accountId" : NumberLong(-1), "cronExpression" : "0 0/3 * 1/1 * ? *", "schedulerType" : "SYNC_JOBS", "active" : true, "dirty" : true, "mandatory" : true, "deleted" : false }) |
REPORTING_EXPORT_COLUMN_ORDER_ENABLED | Ensures Order of the columns in exports come exactly how they come in UI dashboards |
REPORTING_PIVOT_FLAT_RESPONSE_FILTER_ENABLED_ENGINES | Ensures that widgets plotted from different backed reports come as single file only in exports and doesn't break into multiple sheets PLATFORM |
REPORTING_EXPORT_DEFAULT_PIVOT_REQUEST_ENABLED_ENGINES | Ensures that widgets plotted from different backed reports come as single file only in exports and doesn't break into multiple sheets PLATFORM |
EXTERNAL_SHARE_V2_ENABLED | Should be enabled by default |
PROCESS_EXECUTION_REPORT_CASE_PROP_FROM_DIMENSIONS_ENABLED | Helps plot case custom fields with Process execution analytics reports |
CAMPAIGN_PERFORMANCE_REPORT_ENABLED | Enables Live Outbound Campaign Reports |
CASE_REPORTING_SNAPSHOT_CONFIGURED_FIELDS - CaseWorkflowSnapshotRepor | Case Workflow Snapshot Report |
VOICE_LEAD_EVENT_CALL_RESULT_PREDICTION_REPORT_ENABLED | Enables lead ingestion DP on UI |
For Live ACD Report and SC | |
UNIFIED_ANALYTICS_REPORTING_ENGINE | enable unified analytics |
REPORTING_USER_CUSTOM_PROPERTIES_DIMENSION_ENABLED | show user custom fields in UI |
REPORTING_EXPORT_CASE_DESCRIPTION_ENABLED | Controls the case description in export |
ANALYTICS_DASHBOARD_EXTEND_ENABLED ("analytics.dashboard.extend.enabled", BOOLEAN, PARTNER) | Extended Db functionality (child parent DB) |
SHOW_UNIFIED_ANALYTICS_DB_FILTER | To enable pipeline dimension filters as DB level filters |
REPORTING_CSV_EXPORT_ROWS_LIMIT | To increase export row limit in csv format |
REPORTING_STORE_VOICE_CALL_ATTEMPT_DETAILS_IN_LEAD_EVENT | To Enable Attempt Count in Inventory Report |
SFTP_EXPORT_DATE_FOLDER_ENABLED_FORMAT partner string dp with value dd-MM-yyyy | datewise folder for sftp export |
REPORTING_DASHBOARD_DEFAULT_TIME_RANGE | changes default time time range on db |
reporting.spr.task.engine.enabled | Enable task reporting in UI |
REPORTING_CUSTOM_PROPERTY_AS_METRIC_ENABLED | CF as measurment |
DATE_CUSTOM_PROPERTY_MEASUREMENT_ENABLED | Date type CF as measurement |
REPORTING_SELECTED_DATE_INTERVAL_SCRIPT_MEASUREMENT_ENABLED - Partner, Boolean | boAt use case, AvailabilitySLA https://sprinklr.atlassian.net/browse/CARE-3073 5 |
CALCULATE_USER_OCCUPANCY_WITH_ASSIGNMENT_REPORT | Occupancy fix for time spent in status with any case assinged |
Steps for new occupancy job enablement Schedule com.spr.scheduler.jobs.reporting.sla.UserOccupancyJob ( sample - https://qa4-red.sprinklr.com/api/v1/partner/checkJobTriggers?schedulerType=all&ids=4000[…]b&queryType=SCHEDULED&accountId=&jobData=&jobDataKeyValue=) Enable DP - REPORTING_NEW_USER_OCCUPANCY_JOB_ENABLED("reporting.new.user.occupancy.job.enabled", BOOLEAN, PARTNER) DP to ensure that occupancy data is not corrupted if there is delay in User Availability SLA Report USER_SLA_RECORD_BATCH_TIME_CHECK_ENABLED("user.sla.record.batch.time.check.enabled", BOOLEAN, PARTNER) | |
REPORTING_INCLUDE_DELETED_USERS_IN_LOOKUP("reporting.include.deleted.users.in.lookup", BOOLEAN, PARTNER) | To enable deleted used in user lookup |
CASE_WORKFLOW_SNAPSHOT_REPORT_ENABLED -> true CASE_REPORTING_SNAPSHOT_CONFIGURED_QUEUES -> queueId CASE_QUEUE_SNAPSHOT_REMOVE_ADDITION_RECORDS_ENABLED -> true CASE_WORKFLOW_SNAPSHOT_REPORT_USER_ASSIGN_FROM_REMOVAL_ENABLED -> true CASE_WORKFLOW_SNAPSHOT_REPORT_OLD_VALUES_ENABLED -> true | To enable Queue Snapshot metrics in reporting. |