Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Purpose

This is a convenience view that was helpful in building out the PowerBI and QuickSight starter kits. For a given school, it simply selects the most recent grading period from the GradingPeriodDim View. Part of the Core View Collection.

SQL Object

analytics.MostRecentGradingPeriod

Usage Notes

This view may have poor performance. It is not recommended to rely directly on it for real-time access. In the two starter kits, the view contents are read into separate data models and cached periodically (either in the SQL Server Analysis Services tabular data model, for PowerBI, or in the "EWS Data Mart" database for QuickSight).

Structure

ColumnSource TableSource Column or ValueData Type
​SchoolKeyGradingPeriodDimension​SchoolKey​int​
GradingPeriodBeginDateKeyGradingPeriodDimension​Max(GradingPeriodBeginDateKey)nvarchar(30)



Contents

Table of Contents