Community

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
a1222679
Community Contributor

Multiple Due Date Assignments

Jump to solution

I've noticed that assignments with multiple due dates show 'null' in the Due_At column of the Assignment_Dim table.  In my query builder I've joined Assignment_Dim.Assignment_ID=Course_Dim.Assignment_ID.  Might linking these two dimension tables to Assignment_Fact (which I don't have available to me yet but soon will) using the Assignment_ID key give me the various due dates linked to a single assignment?

Thanks in advance,

Daniel.

1 Solution

Accepted Solutions
apritchett
New Member

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 multiple due dates; they don't exist in the ASSIGNMENT_DIM.  The dates you are looking for are located in the  ASSIGNMENT_OVERRIDE_DIM in the DUE_AT column. 

View solution in original post

2 Replies
apritchett
New Member

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 multiple due dates; they don't exist in the ASSIGNMENT_DIM.  The dates you are looking for are located in the  ASSIGNMENT_OVERRIDE_DIM in the DUE_AT column. 

a1222679
Community Contributor

Hi Aaron, I hadn't found the answer yet so thank you for your work.  I really appreciate it.  I'll link that table in and rerun my query.  

Thanks again Aaron.

Best,

Daniel