I need Time dimensions so I created one using SSAS 2008 and selected option 'Generate a table table on the server' and I have the dimension but here are my issues:
1) I cannot find physical table? Where does the data located? How can I generate the table so I can modify the dates if necessary? What is the practise of Time dimension There seems to be several options which don't make much usage sense to me :)
2) I added the dimTime to my cube but in dimension usage there is no relationship so I presume that will not work but my question is is there any reason to use 'no relationship' in practise?
Many thanks in advance