locked
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.

     

    Thanks!

    Friday, September 26, 2008 3:51 PM

Answers

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]

     

    Parameter

    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