Display the selected quarter and previous 5 quarters

[srinu_anu2007]

Hi,

I have quarter prompt and have to display the selected quarter and previous 5 quarters. How to achieve these using DMR model?

Ex. If user select the Q3 2013 and have to display directly Q4 2011 there is no need to display 2012 quarters and 2011 quarters upto q3 2011(Display Quarter based on the selection of 2-Year (Current and Previous Year) in chart report.

Any ideas?

Thaks,
Sri.

[MFGF]

Hi,

I have quarter prompt and have to display the selected quarter and previous 5 quarters. How to achieve these using DMR model?

Ex. If user select the Q3 2013 and have to display directly Q4 2011 there is no need to display 2012 quarters and 2011 quarters upto q3 2011(Display Quarter based on the selection of 2-Year (Current and Previous Year) in chart report.

Any ideas?

Thaks,
Sri.

Hi,

Sorry - I can't make much sense of your description - it's not really clear from your example what you want. If we assume the title of the post is what you are looking for (Display the selected quarter and previous 5 quarters) then an expression such as the following should do the trick:

lastPeriods (6,[Your Quarter Level] -> ?Qtr?)

MF.

[srinu_anu2007]

Sry for that. What iam trying to say is i have to Display Quarter based on the selection of 2-Year (Current and Previous Year). Sort in ascending order

ex: Chart Report: Category(X-Axis): Q1 2012 Q2 2012 Q3 2012 Q4 2012 Q1 2013 Q2 2013 Q3 2013(iam Selecting Q3 2013) and i have to display Q4 2011(for 2 year/7quarters should display)

is it make sence? sorry for my poor explanation.

Thanks,
Sri.

[MFGF]

Sry for that. What iam trying to say is i have to Display Quarter based on the selection of 2-Year (Current and Previous Year). Sort in ascending order

ex: Chart Report: Category(X-Axis): Q1 2012 Q2 2012 Q3 2012 Q4 2012 Q1 2013 Q2 2013 Q3 2013(iam Selecting Q3 2013) and i have to display Q4 2011(for 2 year/7quarters should display)

is it make sence? sorry for my poor explanation.

Thanks,
Sri.

Sorry - I still don't get it. If you select Q3 2013, which quarters to you want to see in your report? Seven quarters prior (as in your ex) would go back to Q1 2012. Where does Q4 2011 come in?

MF.

[srinu_anu2007]

 If you select Q3 2013, I have to show prior 7 quarters.

Thanks,

[Francis aka khayman]

i'll take this one away from MFGF...or maybe not  ::)

is the selected quarter included in the 7 quarters or not? whatever ... the solution is a variety of:

lastPeriods (7,[Your Quarter Level] -> ?Qtr?)

or

set([Your Quarter Level],lastPeriods (7,lag([Your Quarter Level],1) -> ?Qtr?))

[srinu_anu2007]

Thank U very much.

[MFGF]

i'll take this one away from MFGF...or maybe not  ::)

is the selected quarter included in the 7 quarters or not? whatever ... the solution is a variety of:

lastPeriods (7,[Your Quarter Level] -> ?Qtr?)

or

set([Your Quarter Level],lastPeriods (7,lag([Your Quarter Level],1) -> ?Qtr?))

...or, of course lastPeriods (8,[Your Quarter Level] -> ?Qtr?) (if you want the selected quarter and the seven prior quarters)

We did advise yesterday that lastPeriods (6,[Your Quarter Level] -> ?Qtr?) would give you the selected quarter and the five prior quarters (as per the title of this thread), and it's not such a big leap to realise that lastPeriods (8,[Your Quarter Level] -> ?Qtr?) would give you the selected quarter and the seven prior quarters. You could have saved yourself a day with a little experimentation :)

MF.

[srinu_anu2007]

Yes MF I can save my day but the thing is they made the package is wrong and my project got started from scratch and recently. they are checking with the all functionality's whether it wil work out or not. Thanks for ur suggestions.

Thanks,

[srinu_anu2007]

Hello BSP and Team,

The below code is not working and most thing is to update is i have Month is coming from different dim and year is coming from diff.dim's so i dont know how  to relate b/w them. set([Your Quarter Level],lastPeriods (7,lag([Your Quarter Level],1) -> ?Qtr?))
[/quote]

For Ex: if i select Feb and 2014 and then i want to show 2014 Feb, 2014 Jan, 2013 Dec, 2013 Nov.etc.......

What iam getting the output is Month:Feb and year:2014 i have selected using this function lastperiods(7,[Month])->?Month?) and same as for Year and iam getting 2014 Feb, 2013 Feb, 2012 Feb etc... 2014 Jan, 2013 Jan, 2012 Jan ..etc like this iam getting.

Is there any relation for year and month and as i knew there is no joins in DMR. Can any one assist the same?

[srinu_anu2007]

Hello I have Year and Month dimension' where Year is having the hierarchy which is having members and members having 2011,2012 to 2016,2017,2017 and Month Dimension is hving 1 month hierarchy and members and which is having Total Year which is having H1 and H2 and H1 is having Q1 and Q2 and H2 is Q3 and Q4 and Q1 is Jan, Feb, Mar.....etc

I have year prompt where iam selecting 2014 and Quarter is Q1, I have a simple chart and X-axis is having years(20011,...2017) Q1 Q2 Q3 Q4 and

now i want to display 2014 Q1 and 2013 Q4, 2013 Q3,2013 Q2 etc........



Any ideas

[srinu_anu2007]

hello i am very near to close my solution here it is am achieving i have selected in Year promt is 2014 and Quarter is Q1 and iam displaying only 2014 Q1 but i want to display previous 7quarters.

Please help on the same.



Any ideas
[/quote]

[MFGF]

Hi,

If you have entirely separate year and quarter dimensions, how can you know which quarters belong to which years? Normally a Time Dimension would have a year level and a quarter level, with four quarters belonging to each year at the level above. Since you don't have this, how can you know which quarters belong to which years? It seems to me this is the crux of your problem - if you can explain the logic we might be able to suggest something...

MF.