Forum Discussion
What is wrong with my structure?
Hi there I have a data structure consisting of a fact table and i've joined a general date dimension to that table via a full date. I'm using import as the query method. I've used this structu...
From everything that I am seeing, it is your time component that is causing the problem, you should create another column that is only the Date component and join on that. the 12:00:00 AM entries join correctly because a Date value with no time component is a 0 for the decimal component, which means 12:00:00 AM.
Greg_Deckler
Community Champion
Community ChampionFrom everything that I am seeing, it is your time component that is causing the problem, you should create another column that is only the Date component and join on that. the 12:00:00 AM entries join correctly because a Date value with no time component is a 0 for the decimal component, which means 12:00:00 AM.
Big ups Greg_Deckler.