12/6/2011 6:50:23 AM
Amit Karkhanis -
This is a second part in the series "Considerations for Time Dimension". In the Part 1, we have briefly discussed on the two types of the Time Dimension Structures i.e. Regular time dimension and Server time dimension. We have also started with the first out of the three creation methods which is "Use an existing table". In this post we will be discussing on the next options which enables generating a time table if it is not already available in the data warehouse.
Generate a time table – When no time table is available in the source database; Dimension Wizard in BIDS provides an option to create a time dimension using one of the following options.
Generate a time table on the server – This option generates and stores the time dimension directly on the “Analysis Server” instead of in the data source and hence known as “Server Time Dimension”. This eliminates the need to create and maintain a separate time table in the Data Warehouse database. This option may be selected in case…
Once created, the next step is defining the relationship between this dimension and the corresponding measure group in the Dimension Usage tab of the cube designer.
The Wizard steps for this option are same as the first three steps in the previous option except the “Generate Schema Now” in step 3. Once the solution is deployed, the dimension gets directly created in the deployed SSAS database.
Hope it’s now easy for you to build a time dimension with these available options. One thing I would like to mention here is the advantage of generating a time table through Dimension Wizard. The time dimension thus created is preconfigured with correct properties which enables it to take the advantage of the built in time intelligence in SSAS. This built in time intelligence support queries like Period-to-date, Moving averages, Growth over a period of time etc.
If you liked the posts, do like us on FaceBook at http://www.FaceBook.com/SQLServerGeeks
Amit Karkhanis (Member since: 3/14/2011 10:05:08 AM)
View Amit Karkhanis 's profile
Leave a comment