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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

YTD

Status
Not open for further replies.
NotSQL

NotSQL

Technical User
May 17, 2005
205
GB
Hi Guys,

Im pretty new to Analysis Service and would like to create a YTD measure with in my cube. How would i go about doing something like this?

Regards
Dave
 
Sort by date Sort by votes
The simple answer is

Sum(YTD(),[Measures].[YourMeasure])

This assumes you have a correctly defined time dimension/hierarchy with a Year defined as type 'years'

A
 
Upvote 0 Downvote
And do you do this within the caluclations tab? My Time dimension is fine...
 
Upvote 0 Downvote
Prior YTD you would implement using the ParallelPeriod() Function.
 
Upvote 0 Downvote
YTD:
Sum(PeriodsToDate([Dim Time].[Time Hierarchy].[Year], [Dim Time].[Time Hierarchy].CurrentMember), [Measures].[MeasureName])

Prev YTD:
(ParallelPeriod([Dim Time].[Time Hierarchy].[Year], 1), [Measures].[YTD])
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

buddafish
  • Locked
  • Question
YTD - Measure oddity
Replies
3
Views
79
MDXer
MDXer
Elmiira
  • Locked
  • Question
How to create YTD previous year calculated member?
Replies
2
Views
74
Elmiira
Elmiira
Injun
  • Locked
  • Question
WTD, Previos WTD, MTD , Previos MTD ,YTD
Replies
0
Views
38
Injun
Injun
Shab
  • Locked
  • Question
Time Intelligence Wizard YTD and error message
Replies
0
Views
44
Shab
Shab
craig322
  • Locked
  • Question
Prior YTD formula
Replies
0
Views
53
craig322
craig322

Part and Inventory Search

Sponsor

Back
Top