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 derfloh 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
Joined
May 17, 2005
Messages
205
Location
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 Question
YTD - Measure oddity
Replies
3
Views
283
MDXer
MDXer
Elmiira
  • Locked
  • Question Question
How to create YTD previous year calculated member?
Replies
2
Views
233
Elmiira
Elmiira
Injun
  • Locked
  • Question Question
WTD, Previos WTD, MTD , Previos MTD ,YTD
Replies
0
Views
133
Injun
Injun
Shab
  • Locked
  • Question Question
Time Intelligence Wizard YTD and error message
Replies
0
Views
162
Shab
Shab
craig322
  • Locked
  • Question Question
Prior YTD formula
Replies
0
Views
140
craig322
craig322

Part and Inventory Search

Sponsor

Back
Top