Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aravula
Starting Member
5 Posts |
 Posted - 2013-09-11 : 11:23:24
|
| Hi, I am new to ssas and trying to create a Hierarch Like Year - Month - Day. I have only one date column in the table and I need to use that and create a hierarchy. Can someone help me how to do it.Thanks,aravula |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-09-12 : 16:27:37
|
| you can add a time dimension by creating derived columns out of date column using functions like YEAR,MONTH,DAY etc to generate year, month etc values. then make the type of attributes as Year. Month etc in SSAS and make dimension type as Time.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
aravula
Starting Member
5 Posts |
Posted - 2013-10-07 : 09:04:35
|
| Thank you. I followed the same steps. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-08 : 00:17:27
|
| Welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Date Hierarchy