23Q1 Release Notes
Release summary
The TV Analytics 2023 Q1 release includes the following features and bug fixes.
New product features
The features included as part of this release are:
Quality of Experience reporting
New DWH Tableau dashboard added for Quality of Experience w.r.t content playback.
Note:
QOE values are derived/calculated values based on the playback metrics and playback events data reported to DWH by the client app. Accuracy of QOE depends on the client-reported data as per the spec.
This Dashboard is a work in progress and is provided for early-access use. So validation is not complete and the final release version is yet to be planned.
Bug fixes
Major bug fix in data aggregation for playback session duration and performance
Major bug fix done in data aggregation for playback session duration calculation and performance optimization on table scanning for incremental refresh. Because of this backend fix, the existing DWH Tableau dashboards ("Content Consumption Dashboard" and "Consumption KPI Dashboard") will be displaying lower values for playback duration when compared to the previous version after this upgrade.
Bug fixes done in existing reports (mentioned in the “Resolved issues” section).
Backward compatibility consideration
OPF | 2022 Q2 STD | 2022 Q3 STD | 2022 Q4 STD | 2023 Q1 STDO 23.12.STD0 |
|---|---|---|---|---|
DWH GIT Details– (https://gitlab.hq.k.grp/dtv-analytics/dtv-analytics/-/tree/DWH_REL_23Q1_STD1 git commit sha 5cb51ed057fc527b800aa38d7e8f23a3f878d57b) |
List of known issues
The following issues are still open (not resolved) in this release, TV Analytics 2023 Q1.
Key | Summary |
DTVANALYTI-583 | Overview dashboard not loading due to WLM error on cputime exceeded |
DTVANALYTI-582 | [Account Dashboard- Details] While selecting latest activity time report is showing wlm error on cputime exceeded |
DTVANALYTI-511 | 2x records in activities table with same activityid |
DTVANALYTI-507 | In GDPR SAR Report "postal zip code" is not displaying |
DTVANALYTI-506 | Slowness of dashboards |
DTVANALYTI-500 | Account Status - Graphical View - number of accounts not reported if no new account was created today |
DTVANALYTI-493 | Buffering rate sheet is not available in QoE report due to BE calculation not ready |
DTVANALYTI-492 | Currently QoE dashboard name shows QOS overview dashboard instead of QoE in Tableau deployment |
DTVANALYTI-491 | Email subscription report shows ##### values |
DTVANALYTI-490 | Locale should add in Consumption KPI |
DTVANALYTI-489 | Need correction in daily average devices kpi consumption |
DTVANALYTI-477 | Issue with active user in QOE dashboard |
DTVANALYTI-451 | Hardware Type not displayed in Account Recent Activities and Account Player Error tabs but correctly displayed in Account Content Views |
DTVANALYTI-449 | The dashboard loads slowly at first but quickly after that |
DTVANALYTI-383 | [22Q4][TABLEAU] Deleted Products are showing in Tableau report |
DTVANALYTI-372 | [22Q4][TABLEAU] Pagination not resetted in operational reports |
DTVANALYTI-345 | Data Validation to show error status only |
Resolved issues
The following issues are fixed, and these bug fixes are part of this release.
Key | Summary |
|---|---|
DTVANALYTI-454 | QoE dashoard UI and functional issue |
DTVANALYTI-416 | [23Q1 Backend and 22Q4 Tableau reports] Few tableau reports Deployment error |
DTVANALYTI-482 | DBT incremental refresh there is count mismatch between raw and aggregated table |
DTVANALYTI-495 | Account Recent Activities doesn't show the same list of Content Locale |
DTVANALYTI-450 | Security kpi dashboard shouldn't be part of tableau release |
DTVANALYTI-461 | QoE dashboard Functional and UI changes |
DTVANALYTI-466 | QXC Reports STCU is not being reported |
DTVANALYTI-426 | Error status text not displayed in metadata purge report when filter by error |
DTVANALYTI-434 | Report not showing datetime picker |
DTVANALYTI-438 | Functional and ui issue in account creation report |
DTVANALYTI-445 | Wrong data shown in operational kpi dashboard |
DTVANALYTI-439 | When changing dim_date on Apply, the source was missing on the Action option here |
DTVANALYTI-427 | Account Overview - strange format number reported in "Top 10 Account By Playback Session" |
DTVANALYTI-428 | Account dashboard performance issue observed |
DTVANALYTI-409 | Recent Activities tab shows "watch" activity with "Content ID" and "Content Name" = N/A |
DTVANALYTI-444 | Dashboard loading performance issue |
DTVANALYTI-465 | Consumption Active Accounts count appears wrong |
DTVANALYTI-415 | [22Q4 Report with 23Q1 Backend in Stagingclone & nagrainternal site] Device Creation Report layout issue |
DTVANALYTI-453 | QoE Dashboard issue |
DTVANALYTI-463 | QXC Dashboard widgets replaced with ############# |
DTVANALYTI-496 | Operational KPI Dashboard - reported "Error Percentage" looks different |
DTVANALYTI-494 | Operational KPI Dashboard - "Error Top 10" area reporting more than 10 entries |
DTVANALYTI-467 | Operational KPI Dashboard Average bitrate calculation error |
DTVANALYTI-499 | [Online Documentation] Account Status - Tabular View - no Search box available in the report |
DTVANALYTI-440 | In Content_Consumption table, channel name is Null |
DTVANALYTI-498 | Consumption KPI Dashboard - "Total Active Accounts" area reporting different values |
DTVANALYTI-442 | In Content_Consumption table, app session id is wrong since May 3rd |
DTVANALYTI-485 | Content group if locale info is not available content group is not present in aggregated table |
DTVANALYTI-484 | Playback Metrics aggregated metrics created two session if client dont pass contentid/content type |
DTVANALYTI-486 | Aggregated recordings table have some recordings missing |
DTVANALYTI-464 | Report has no genres showing |
DTVANALYTI-342 | Clone of issue with summary: Tableau recording reports missing data |
DTVANALYTI-414 | [22Q4 Report with 23Q1 Backend in Stagingclone & nagrainternal site] Account Creation and Timeseries reports shown wrong data |
DTVANALYTI-443 | [Aggregation] Include start over or start-over part of VOD content type |
DTVANALYTI-470 | Issue in playbackduration calculation |