Restricting certain months shown in prompt in dimensional reporting

[cognos05]

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

[MFGF]

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.

[cognos05]

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

[MFGF]

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.

[cognos05]

Thanks MFGF, It worked.