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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Date Hierarchy

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

aravula
Starting Member

5 Posts

Posted - 2013-10-07 : 09:04:35
Thank you. I followed the same steps.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-10-08 : 00:17:27
Welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -