...
Currently, none of the objects have a name that violates this constraint. To help avoid problems with future views, it is proposed either truncate "Dimension" to "Dim" or drop the word altogether.
| Old Name | A - Truncate | B - Drop |
|---|---|---|
| analytics.StudentDimension | analytics.StudentDim | analytics.Student |
| Notetip |
|---|
Is there too much risk of confusing the |
Status
| Warning |
|---|
Requesting additional input before committing. Respond to Stephen Fuqua, #dev-analytics-middle-tier on Slack, or with a comment on this page. |
Multi Data Standard Support
...
- If table
AddressTypeexists, then install Data Standard 2. - Else if table
VersionLevelexists, then install Data Standard 3.1. - Else if table
DeployJournalexists, then install Data Standard 3.2. - Else throw an error: "Unable to determine the ODS database version".
Status
| Note |
|---|
Likely to proceed with this design. Stephen Fuqua |
Student, Parent, and Staff Keys
...
Change all instances of StudentKey , ContactPersonKey , and UserKey to use the corresponding "UniqueId" column from the source table.
| Tip |
|---|
Will proceed with this design. Stephen Fuqua |
Descriptor and Type Mapping
...
Those who install the Analytics Middle Tier will need to carefully assess their Descriptors and Types, and then manage the DescriptorMap table (and TypeMap , for Data Standard 2) accordingly. The release notes for 2.0 will provide a script that maps the default Ed-Fi Descriptors and Types as a starting point.
Status
| Tip |
|---|
Will proceed with this design. Stephen Fuqua |
Student Dimension Uniqueness
...
These problems are rather ugly, and would be difficult to detect unless you're actively looking for them. Furthermore, while writing an updated SQL query was easy, how would one represent this in a business intelligence tool like Tableau or PowerBI?
Status
| Warning |
|---|
Requesting additional input before committing. Respond to Stephen Fuqua, #dev-analytics-middle-tier on Slack, or with a comment on this page. |