Previous Year and Previous Month

[srinu_anu2007]

how to show previous year and previous month when you are selecting Current month and current year.

ex:i am selecting current month:Aug and Current year:2014 and i need to show Jul 2013.

I have Month level hierachy in my cube and MUN for Aug is: [rp_gcrs].[rp_period].[rp_period].[Month]->:[TM].[rp_period].[rp_period].[@MEMBER].[Q3 2014^Aug 2014]. Can someone help me.

Thanks

[MFGF]

how to show previous year and previous month when you are selecting Current month and current year.

ex:i am selecting current month:Aug and Current year:2014 and i need to show Jul 2013.

I have Month level hierachy in my cube and MUN for Aug is: [rp_gcrs].[rp_period].[rp_period].[Month]->:[TM].[rp_period].[rp_period].[@MEMBER].[Q3 2014^Aug 2014]. Can someone help me.

Thanks

The month before the one selected can be targeted using the prevMember() function

eg prevMember([rp_gcrs].[rp_period].[rp_period].[Month]->:[TM].[rp_period].[rp_period].[@MEMBER].[Q3 2014^Aug 2014])

The same applies for members at the Year level.

Cheers!

MF.

[srinu_anu2007]

Hi MF,

Thanks your reply. I tried the same function and its retreving July 2014 but i need to show July 2013.

Thanks,

[MFGF]

Hi MF,

Thanks your reply. I tried the same function and its retreving July 2014 but i need to show July 2013.

Thanks,

In that case, you need to use the parallelPeriod() function around all of this

eg

parallelPeriod([Your year level], 1, <the expression you are using above>)

This assumes that the year level is somewhere above the month level in your time hierarchy.

MF.

[srinu_anu2007]

below expression is not giving any value.

parallelPeriod ([rp_gcrs].[rp_period].[rp_period].[Year and Variances],1,prevMember([rp_gcrs].[rp_period].[rp_period].[Month]->:[TM].[rp_period].[rp_period].[@MEMBER].[Q3 2014^Aug 2014]))

[MFGF]

below expression is not giving any value.

parallelPeriod ([rp_gcrs].[rp_period].[rp_period].[Year and Variances],1,prevMember([rp_gcrs].[rp_period].[rp_period].[Month]->:[TM].[rp_period].[rp_period].[@MEMBER].[Q3 2014^Aug 2014]))

Well, I don't have access to your member tree to see whether the member you are trying to target actually exists...

MF.