Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Analysis Services 2005 MDX: Year End calculation
Hi again, I'm not sure if my previous message didn't make sense to anyone as I haven't had any responses. So to put it simply I would like to know what the MDX would be to get the YTD amount for December without having to hardcode a specific year and month. Any help would be much appreciated...- SSASUser
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Analysis Services 2005 MDX: Year End calculation
I’m having problems trying to get the YTD value for December only which needs to apply to all levels in the Calendar hierarchy. My calculation for YTD uses the Time calculations concept for handling YTD, Prior Year etc. -- YTD CALCULATIONS ([Time Calculations].[YTD]=...- SSASUser
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
