Hey everyone! New day new question!
Well. I have two tables, one is a fact table about applications and one is a dimension table about applicants. I've performed an outer join between the two tables on applicantid. I also created a date bridge table now that I've joined them with key applicationid. Note that one applicant can have many applications.
Turns out, there are applicants with no applications, meaning I get "-" on the joined table for some applications, because they didn't ever exist in the applications table in the first place.
A strange thing happened...
1) Those applicants with no applications get included in my count if I do raw date field selections , eg from >=01/09/2010<=31/08/2011 but don't get included if I select year 2010-2011 and DateType='Inserted' as flag. Second approach is what I want to do.
So. What is going wrong here please? 😩
I've tried in my script nullascount , autonumber(ApplicantID&'|'ApplicationID) (gives still "- "), nullmaps, rowno() so that i'll be able to count them... yet no luck.
I also don't understand the reason why this is happening as long as date bridge is about my raw date fields.
🆘
