Hi I have a Time dimension and my members look like this.
I have All Fiscal year members as the top member,below which I have fY2005, fy 2006,until fy2014. I wanted to display last three completed fiscal years- fy 2011,fy2012,fy2013.
How to achieve this
Thanks,
Last periods(2,2015) gives 2015,2014. I need 2014,2013.
Quote from: Manu0521 on 16 Apr 2014 09:07:13 AM
Last periods(2,2015) gives 2015,2014. I need 2014,2013.
Am I missing some obvious problem? What results do you get if you use lastPeriods(2,[your 2014 year member])
Isn't this just a logical progression from what you have? Or am I missing something obvious (which is quite normal for me) :)
MF.
No, lastperiods(2, X)
is the last child of a member. say my last child is 2014,'
my expression would be lastperiods(2,lastchild(member))
lastchild(member) would give me 2014.
I need to display only 2013, 2012.
The above result is giving me 2014 and 2013.
Thanks
Quote from: Manu0521 on 16 Apr 2014 10:18:33 AM
No, lastperiods(2, X)
is the last child of a member. say my last child is 2014,'
my expression would be lastperiods(2,lastchild(member))
lastchild(member) would give me 2014.
I need to display only 2013, 2012.
The above result is giving me 2014 and 2013.
Thanks
Oh - I see :)
What about
lastPeriods(2,prevMember(lastChild([member])))
MF.
Hi,
Try to use the below expression and use MUN from the current year(2014) and the output would be 2014,2013,2012
lastPeriods(3,#'[P.Nam].[Dim.Name].[Hierarchy Name].[Year]->:[TM].[Dim.Name].[Hierarchy Name].[@MEMBER].['+timestampMask($current_timestamp,'yyyy')+']'#)