I have a time dimension and there is a month level and in this prompt data is shown from jan 2010 till dec 2015 ,
I wanted this prompt to show only months starting from jan 2014 or say jul 2013.
Which function should I use to achieve this .
My months MUN look like this [Sales].[Time Period].[Time Period].[Fiscal Months]->:[PC].[@MEMBER].[20100701-20100731].
Thanks,
Nithya
Quote from: nithya1224 on 06 Nov 2014 08:01:01 AM
I have a time dimension and there is a month level and in this prompt data is shown from jan 2010 till dec 2015 ,
I wanted this prompt to show only months starting from jan 2014 or say jul 2013.
Which function should I use to achieve this .
My months MUN look like this [Sales].[Time Period].[Time Period].[Fiscal Months]->:[PC].[@MEMBER].[20100701-20100731].
Thanks,
Nithya
Your prompt is populated by means of its own query in the report. I'm guessing this has a single query item within it, comprising the Month level of your hierarchy?
If so, replace this with a calculation that uses a tail() function to return the last <n> month members
Coding an expression of
tail([your Month level], 24)
would give you only the last 24 months from the Month level.
Cheers!
MF.
Thanks MFGF,yes this works fine but this will give me till 2015 jun and I have data only till the current month.
last 24 months from current month would be something wat I am expecting.
so should I generate the current month Mun and use that instead of the level in the Tail?
but tail(current month mun,12) did not work.
Thanks,
Nithya
Quote from: nithya1224 on 06 Nov 2014 09:46:20 AM
Thanks MFGF,yes this works fine but this will give me till 2015 jun and I have data only till the current month.
last 24 months from current month would be something wat I am expecting.
so should I generate the current month Mun and use that instead of the level in the Tail?
but tail(current month mun,12) did not work.
Thanks,
Nithya
Use the lastPeriods() function with your generated MUN - that should do the trick :)
MF.
Thanks MFGF, It worked.