I have a question about the submission_dim and determining the difference between the submitted_at and created_at fields.  The submitted_at field matches the time stamp in Canvas that the submission w...

You may already have your answer but I was curious so I went in and started digging around.  To answer your question no, if you connect to the ASSIGNMENT_FACT you will not be able to display the multi...

Thanks to  @brenden_goetz  and  @James  for the great responses.  One of the things I am looking for is for students who call into our Tech Support saying they submitted their paper but it isn't showi...

Greetings Jeffrey, I think I understand what your trying to do so hopefully my answer helps you. First, I would start with the [quiz_fact] and join [quiz_fact].[Quiz Id] to [quiz_dim].[Id] and then [q...

Does CD2 refresh at certain times during the day?  I want to set up a scheduler to pull the latest incremental refresh and load it into our database. 

Does CD2 refresh at certain times during the day?  I want to set up a scheduler to pull the latest incremental refresh and load it into our database. 

I have worked with Canvas and Tableau and I discovered the issue was with Tableau and the way it reads flat files.  For what ever reason Tableau will sometimes have errors reading large flat files.  W...

I noticed this morning that we have a lot of missing data in some of our tables.  I first discovered it in the course_dim and in the course_section_dim.  This causes a problem for us since we run regu...

Greetings Jeffrey, I think I understand what your trying to do so hopefully my answer helps you. First, I would start with the [quiz_fact] and join [quiz_fact].[Quiz Id] to [quiz_dim].[Id] and then [q...

You may already have your answer but I was curious so I went in and started digging around.  To answer your question no, if you connect to the ASSIGNMENT_FACT you will not be able to display the multi...