I am exploring canvas OLAP database similar to this (Canvas Data Portal ) with caliper events captured for canvas. I struggling to relate the content in canvas with caliper.
For example, I am trying to find the number times a user viewed a course announcement. Since the ID for each table(dimension) is not global, i am not able to relate data correctly.
For example, I am looking up id(announcement id) field of discussion_forum_topic in caliper data (object_extensions_enitityid) this field sometimes has id(announcement id) and sometimes has course id (from cvs_course_dim) how do i correctly join the course id in caliper with course_id in canvas, and similarly for other components like announcements, modules etc.
Do you have a documentation or mapping to relate caliper with canvas? If yes, could you share that?
Appreciate your help !
Pooja, greetings! Due to the technical nature of this question I’m going to share this with the Canvas Developers and Canvas Data Services groups in the Community. My recommendation is to also join or follow these groups so you’ll have access to their information and resources!
Kona