Skip to main content
Skip table of contents

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:

  1. 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

  1. 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.

  2. 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)
Tableau (online config) – 4.0.0.20230628120428

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.