Examples of dimension & event files
This page gives an example of cQube Dimension & Event schema for better understanding
Dimension Schema
Ex : School Dimension
This is the data for all schools, clusters, blocks and districts in the state.
If CSV is being ingested, the file name should be -> school-dimension.data.csv
Event Schemas:
Ex : Teacher Attendance
This program entails indicators to monitor compliance and performance of teacher attendance. Following are the reports within this program:
Teacher Attendance Compliance: This report shows the compliance of attendance being marked by teachers.
Teacher Attendance Summary: This report shows the summary of teachers being present in the school (out of the ones marking their attendance).
Following schema will be required to enable the teacher attendance program:
If CSV is being ingested, the file name should be -> teachersattendance-event.data.csv
Note: The name for grammar file & event file should be same. e.g: teachersattendance-event.data.csv , teachersattendance-event.grammar.csv
NOTE : Each metric should be part of a separate event table.
E.g. In teacher attendance event file, we will have 3 tables: one for total_teachers, one for teachers_attendance_marked & one for teachers_marked_present
Last updated