This content has been marked as final. Show 2 replies
Looks like your fact table is CPCFile and Dcstudents.
My suggestion is to concate two table into 1 table
so Your script will be like this:
Disciplineid as disciplineid, schoolid, studentid, therapistid, Date, consult, direct, individual, rate, DC
From CPC File;
studentid, disciplineid, schoolid,