I've just about exhausted all alternatives for implemnting master calendar and could really use some help. I've read all of the discussions very carefully and my results are still not correct. Can someone help me out?
When I create list boxes for the various date fields, there is no resulting lists. For example for months I only get a single month, and if I select it it doesnt highlight the appropriate data.
Here is my load script:
LOADuser_sk, date_day_sk, Date#(date_day_sk,'YYYYMMDD') as[Period Date] FROM event_fact.csv