Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Current »

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)




  • No labels