(Using SQL Server 2008 R2)
Im rather new to SQL Server and certainly to SSAS. AT the moment I am working on a project in which I need to implement SSAS on a SQL Server. The database originates from UniVerse and it does not have a time table I can use as a dimension.
I have found a script that will be able to set up the time dimension table, but:
-how do I add it to the database
-how do I make it available to be chosen as a dimension?
View Complete Post