Analytics & Insights

Release 26.6.1.0

PowerSchool Analytics & Insights version 26.6.1.0 is available

Application | Enhancements

Component

Summary

Release Note

MTSS Student Plans

Attendance data sorting update

The Attendance data component now sorts records in descending order by date (most recent to oldest) by default. Previously, users had to sort manually to view the latest attendance records first.

Application | Resolved issues

Component

Summary

Release Note

Platform (UIHN)

Unable to edit or delete Domain Decodes in Analytics & Insights

Fixed an issue that prevented users from editing or deleting Domain Decode values from the A&I Dashboard UI. Creating new domain values also failed; this is now resolved, and domain values added through the Dashboard UI are saved successfully.

Platform (UIHN)

Data Security Manager and Cohort Manager now set SYS_PARTITION_VALUE correctly on Portal DB tables

A fix has been applied to the Portal UI so SYS_PARTITION_VALUE populates correctly when records are created or updated through Data Security Manager and Cohort Manager. Previously, this field remained null in several Portal database tables, causing downstream ETL processing issues.

What changed:

The Portal applications now derive and set SYS_PARTITION_VALUE on the following tables during create and update operations:

  • SEC_DOMAINS

  • SEC_USERS

  • SEC_GROUP_TYPES

  • SEC_GROUPS

  • SEC_GROUP_USER_MEMBERSHIP

  • SEC_GROUP_STUDENT_MEMBERSHIP

  • SEC_COHORT_USER_MEMBERSHIP

The partition value is derived from the district code associated with the record being created or updated (for example, the domain district code, the user domain, or the logged in user's domain), and is resolved via XTBL_PARTITION_CONTROL.

Impact:

Records created or updated through Data Security Manager and Cohort Manager will now carry a valid SYS_PARTITION_VALUE, which supports correct ETL processing and data partitioning by district. On properly configured tenants, no user facing behavior change is expected.

Important: potential error on misconfigured tenants

On tenants where XTBL_PARTITION_CONTROL does not contain a mapping for a given district code, create or update operations in Data Security Manager or Cohort Manager may return an error indicating that the partition value cannot be resolved for the specified district code.

If this error occurs:

  • Verify that K12INTEL_USERDATA.XTBL_PARTITION_CONTROL contains a valid entry for the district code in question.

  • If the district code is sourced from a domain's Domain Code or Alternative Domain Code field in the Dashboard, confirm that the value is correctly configured.

  • Contact your ETL or CloudOps team to add the missing partition mapping if needed.

Note on existing records

Back population of SYS_PARTITION_VALUE for existing records with null values is being handled separately by the ETL or CloudOps team and is not part of this release.

Dashboard | New features

Component

Summary

Release Note

Academics Analytics

Academics Analytics, Teacher analysis dashboard filter update

The Teacher Analysis dashboard in Academics Analytics requires selecting both a school and a subject before loading, with subject options updating based on the selected school.

Academics Analytics

Academics, AP, AP Enrollment by school visual updated

The district bar chart from the Academics: AP Enrollment by School visual was removed to ensure the title and key insights remain aligned.

Dashboard | Resolved issues

Component

Summary

Release Note

Assessments Analytics

Assessment Dashboard, State, Proficiency Gainers, Stickers, and Sliders Dashboard Year filter dropdown selection updated

The year filter dropdown in the dashboard ensures each year appears only once and selects the intended year without affecting other selections, and this issue is now resolved.

Enrollment Analytics

NY State specific: Special education classification logic update

Students are no longer classified as active in Special Education based on the current year when their program end date has passed and this is now resolved.