Forum Discussion
Date Table Relationships
Anonymous
IF your analysis will be at the day level then during the ETL process modify this column to extract only the date part without the time
IF you also need to analyze things by time then split the column in two columns, one with the date part and one with the time part and create a time dimension as well
Anonymous
IF your analysis will be at the day level then during the ETL process modify this column to extract only the date part without the time
IF you also need to analyze things by time then split the column in two columns, one with the date part and one with the time part and create a time dimension as well
LivioLanzoThat's great, I've just split the column and used the date only and everything works perfectly. Thank you so much for all your help with this.