This content has been marked as final. Show 5 replies
If you have a properly defined time dimension which supports aggregation at year and month level, then provided you do not have future dated data (!) in your system the standard YTD measures created at the appropriate level of aggregation will do what you describe, but the L YTD would have to be done in the analysis itself.
BUT - usually end users ask for this kind of functionality and then subsequently add the requirement that they want to be able to run this 'for any point in time', for which the only way to go is parameters coupled with filter / case logic in the analysis.
Thanks for the reply,
How is the metrics definition going to be able to make the sum to the current date
Are we going to the use the ToDate function
Yes TODATE function must be used with properly defined time dimension hierarchy for Year , Quarter or month till date kind of measure values
Edited by: user2534719 on Jan 29, 2013 8:10 AM
Any suggestions please.
Very suprised to see my messages got deleted from this post
Anyone any idea?