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 Mike Lewis 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
0
0
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
How would i do previous YTD?
 
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
34
MDXer
MDXer
Elmiira
  • Locked
  • Question
How to create YTD previous year calculated member?
Replies
2
Views
25
Elmiira
Elmiira
Injun
  • Locked
  • Question
WTD, Previos WTD, MTD , Previos MTD ,YTD
Replies
0
Views
11
Injun
Injun
Shab
  • Locked
  • Question
Time Intelligence Wizard YTD and error message
Replies
0
Views
13
Shab
Shab
craig322
  • Locked
  • Question
Prior YTD formula
Replies
0
Views
14
craig322
craig322

Part and Inventory Search

Sponsor

Back
Top