Is there any you can add YTD to Time Dimension as attribute? Or it has to be Calculation? Then how do we do this? Is this need to base on Dimension or Measure? I would prefer this to be base on dimension and show in Time dimension hierarchy.
Any inputs on this are highly appreciated.
If you are using Analysis Services 2005 you can open the cube editor and then click on the "Add Business Intelligence" button you will get a wizard that will guide you through the process of adding a "Period Calculations" attribute hierarchy to your time dimension which can be used to support YTD, QTD, MTD and other period calculations.
The following is a link to an excellent article on the "Time Intelligence" wizard that was published in SQLServer magazine:
http://www.windowsitpro.com/Article/ArticleID/46157/46157.html
|||
Although you need to be aware that some of the calculations produced by the Time Intelligence Wizard, including the YTD calculation, don't actually work. See:
http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!379.entry
|||
There are several ways to accomplish this. If your users want a way to select Monthly values vs, QTD, YTD from a selector/slicer you will need to create a Time Utility Dim or a Time Ref Dim.
This Dim will only contain one member for the lowest level of detail. ie. Month or Daily. You would then create calculated members to compute YTD and anyother values that are based on what the user has selected in the Time Dim.
|||Can this be done in AS 2005?
No comments:
Post a Comment