While attempting to build my own Date/Time dimension in SSAS I was confused by the date/time attributes that Microsoft supplies. The SSAS help discusses each attribute in alphabetical order, but no attempt is made to organize them in a useful way. This spreadsheet (via Google Docs) is my attempt at organizing the SSAS date/time attributes: http://spreadsheets.google.com/pub?key=pIsKma8AZfzY_KETerdpcAA. I hope you find it useful.
Wednesday, June 04, 2008
Subscribe to:
Post Comments (Atom)
2 comments:
Pingback. Link to this post was added to our website in [Analysis Services Articles]/[Time Dimension] section:
http://www.ssas-info.com/analysis-services-articles/59-time-dimension/932-demystifying-ssas-time-dimension-attribute-types
Mark, thank you for supplying this simple yet very effective description of how to uniquely qualify each attribute within a hierarchy.
While trying to figure out exactly what I needed to, this post helped me quickly to find the answer.
Post a Comment