I have created a few fairly basic OLAP cubes using SSAS 2005 in the past. Basically I created a single view that contained all the data that I was interested in used and this as the data view, I then created the calculated columns, dimensions, hierarchies and measures.
I want to start using SSAS 2012 tabular but as I would like to build something a bit more complicated I am working through the microsoft tutorials on the MSDN website. My question is do I need to have a dedicated date table? Obviously I have date fields in my tables order date, created date etc but I do not have a specific date table.
Any thoughts or suggestions would be greatly appreciated.