12/5/2011 6:51:42 AM
Amit Karkhanis -
In Analysis Services, Time dimension has its own importance in the overall data analysis. As we can see that the majority of the BI solution aggregate data over the time periods and hence it is an implicit part and parcel of majority of BI projects.
A time dimension typically contains attributes that represent time periods such as year, quarter, month and day. We can implement the time dimension in Analysis Services cubes using several ways. A cube can contain more than one time dimension or can use several hierarchies from the same time dimension depending on the granularity requirements of the data.
Time Dimension Structure
The time dimension structure depends on how the time period information is actually stored in the underlying data source. There are two basic types depending on the storage of time data.
As I said there are several ways to create a time dimension. See the below screenshot of the Create New Dimension Wizard which provides the following option to create a time dimension. The first two options represent Regular Time Dimension and the third option represents Server Time Dimension. Let’s understand these options with a brief description and the important steps in creating them using the dimension wizard.
So far, we have checked creating a time dimension based on the existing time table in the underlying database. In the next part, we will understand the next option of "Generating a time table".
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