Time Filter RRS feed

  • Question


    Does anyone know if there is a way to link reports to a time filter so that when I choose a particular month the report shows 12 months of data up until that month I selected?  For example if I choose Jun2008 in my time filter I want the report to show Jul2007 through Jun2008.



    Friday, September 26, 2008 3:51 PM


All replies

  • Yes it is possible.

    What kind of report are you using?


    Friday, September 26, 2008 6:49 PM

    I am using an analytic chart
    Friday, September 26, 2008 11:16 PM
  • Not sure what the filter looks like if you are using a tree and referencing the entire hierarchy or just have a list of the months for them to select from.  You could setup the initial query like this (example from Adventure Works):


    select LastPeriods ( 12,[Date].[Fiscal].[Month].&[2004]&Devil ) on columns,

    measures.[reseller sales amount] on rows

    from [Adventure Works]


    and then replace the month selection with a parameter and link your filter to this parameter in the Analytical chart.


    select LastPeriods ( 12,<<EndingMonth>>) on columns,

    measures.[reseller sales amount] on rows

    from [Adventure Works]



    EndingMonth  [Date].[Fiscal].[Month].&[2004]&Devil



    Not sure why the little devils are showing up in the posting, but they are supposed to be the number 6 surrounded by brackets.


    Sunday, September 28, 2008 12:06 PM
  • Thanks so much for the info!!


    Sunday, September 28, 2008 6:01 PM
  • Hi.

    Sure the only you need to do is on the dashboard connection formula put some like that

    lastperiods(12, <<UniqueName>>)

    and thats all.... 

    • Proposed as answer by Edwin Reyes Tuesday, November 12, 2013 5:04 PM
    Tuesday, November 12, 2013 5:04 PM