This section provides an overview of what's new in each release of the Analytics Middle Tier.
Version 2.2.0 (Latest)
Version 2.2.0 comes with a few changes to the Analytics Middle Tier:
- AMT now has official support for postgres deployments. All tests have been run against the postgres implementation using sample data and match the output of the SQL Server counterpart
- The chronic absenteeism view has been modified to clarify what data resides in the view. Instead of a naming convention that uses "isAbsent..." or "isPresent..." the modified naming convention uses "reportedAsAbsent" and "reportedAsPresent". This is to clarify that the data contained within those columns are dependent on how the data was reported. Districts reporting positive attendance will typically use the "reportedAsPresent" columns while districts reporting negative attendance will typically use the "reportedAsAbsent" columns.
- AMT now has a companion repository for community contributed collections. This companion repository can be found at https://github.com/Ed-Fi-Exchange-OSS/Analytics-Middle-Tier-Contrib. Documentation on usage and deployment can be found at Community Contribution Repository
The version 2.1.1 release of Analytics Middle contains a hotfix to add SectionKey to the ClassPeriodDim View. This was added to remove ambiguity and better support referencing ClassPeriodDim with the ODS.
The version 2.1.0 release of Analytics Middle has the following additions to the solution
- Added the chronic absenteeism use case collection.
- Validated support for Ed-Fi ODS/API Suite 3 version 5.0.0
- Included the class period name to the section Dim
The version 2.0.0 release of Analytics Middle resolves several key architectural problems from the original releases, and introduces improvements that make the tool easier to maintain and easier for the community to make contributions. This release includes breaking changes from previous releases.
- Supports Ed-Fi Data Standard v2.2, v3.1, and v3.2 (both 3.2a or 3.2b).
- Thus it supports Ed-Fi ODS/API versions 2.5.1, 2.6, 3.1.1, 3.2.0, 3.3.0, and 3.4.0.
- The names of "dimension views" have been trimmed to use the suffix "Dim" instead of "Dimension".
- All references to Student, Parent, and Staff tables in the Ed-Fi ODS database now utilize the "UniqueId" unique columns instead of the "USI" unique columns.
SchoolYearcolumn has been added to several views, thus facilitating import of Analytics Middle Tier data from multiple year-specific databases into a single data mart.
- The old
StudentDimensionis now two views:
StudentLocalEducationAgencyDim. These two views encapsulate the relationship of a student to an organization entity, including demographic information.
- Fully supports mapping descriptors (and, in Data Standard v2.2, Types) to constant values used by the views — thus removing the previous hard-coding of the views to the out-of-the box Ed-Fi Descriptors (and types).
- There is a clearly defined set of core views that are always installed, and a mechanism for the optional install of use-case specific views. The original Early Warning System and Row-Level Security views have now become optional use-case collections.
- Program-related views were removed, but may be replaced in the future based on community needs.
For more information on these design changes, please see Version 2.0 Requirements and Design.
Some of the enhancements were in response to community-identified issues, which were never logged as bugs per se. They are listed below for completeness along with one community-reported bug.
Brief instructions follow. For more detailed instructions, please see the AMT Deployment Guide.
- Download the compiled application from GitHub, either:
- EdFi.AnalyticsMiddleTier-win10.x64.zip is fully compiled for execution in Windows 10 or Windows Server 2016/2019, with or without the .NET Core 3.1 runtime, or
- EdFi.AnalyticsMiddleTier.zip contains the compiled code without platform optimizations. Requires the .NET Core 3.1 runtime, which can be executed in any .NET Core support environment.
- Unzip the downloaded files, open PowerShell, and navigate to the folder containing the application files.
- Run the application with no arguments, carefully studying the help message for detailed instructions on the command line operation of this tool.
- For EdFi.AnalyticsMiddleTier-win10.x64.zip:
- For EdFi.AnalyticsMiddleTier.zip:
- For EdFi.AnalyticsMiddleTier-win10.x64.zip:
Now with support for Data Standard 3.1! (both ODS/API 3.1 and 3.2). The default installation parameters still correspond to Data Standard 2.x. To install with Data Standard 3.1, add flag
--dataStandard Ds31 to the command. For example:
Or alternately, use the short-hand:
Student enrollment now accepts students with future exit date as being enrolled, whereas before the views were erroneously excluding all students with an ExitDate regardless of when that date occurs.
- Resolve a naming conflict, internal to the views, that impacts ability to add the views directly to PowerBi (bypassing Tabular Data Model).
- Allow re-install after uninstall
The installation process has changed slightly, to make it easier to introduce new optional domains. Now, to install the optional indexes, use argument
-o Indexes instead of the old
This release includes the EWS views created for the QuickSight starter kit.
StudentDataAuthorizationDimension has a breaking change in it, reporting on
SectionId instead of
SectionKey. There was previously an inconsistency with
UserStudentDataAuthorization, which used the
Section.Id instead of concatenating the natural key into a
SectionKey. Since solutions that use this dimension are providing student-level authorization, not section-level, it was appropriate to (a) change for consistency and (b) not confuse people further by keeping the name
SectionKey. Per normal SemVer rules this should have bumped the version number to 2.0.0, but we're breaking that rule since we're still very early in the rollout of this application.
StudentSectionGradeFact, letter grades are now translated to numeric grades, with the help of a new table
analytics_config.LetterGradeTranslation. Default values are provided. When a student has a numeric grade, the fact view will use the numeric value. If the numeric value is null, then the view attempts to use a translated letter instead.
- No labels