I'm building a cube and I want to add a time dimension. I don't have any time table in my OLTP (Source) database. So I tried to use the wizards from SSAS to create a time (date) dimension.
I have choosed the "Server time dimension" one. It did create all what I need with all the hierarchies. But when I tried to add time business intelligence with the wizard, it doesnt see my new time dimension.
I have checked if the type was "time" for the dimension and It was ok.
So I don't know why the Time intelligence can't see my time table .... btw, I start the Business Intelligence wizard from the cube.
View Complete Post