1 Reply Latest reply on Apr 6, 2016 9:48 AM by diego.medrano

    Looking to create a dynamic date filter within an SSAS date hierarchy

    Peter Holcomb

      I'm looking to create a monthly sales report that displays YTD Sales premium through the end of the previous month & ignores any current month sales.

       

      The filter should allow each of the current year's months to display their sales numbers with the exception of the current month.

       

      My report uses an SSAS cube with a Date hierarchy (Year / Year-Quarter / Year-Month / Calendar Date).

       

      How can I apply a date filter that updates automatically when opened & avoids me having to update it each month to exclude the current month?