6 Replies Latest reply on Feb 15, 2012 9:23 AM by Peter Hopwood

    Filtering to current date when using a cube as a source

    Adam Goodwin

      Hi,

       

      I've been trying to find a way to do this but haven't been able to yet. When I have a SSAS cube as a data source, can I set up filters related to the current date for the cube's date hierarchy?

       

      For example, with a table, could I set up a filter that will mean the table always shows data for the current day?

      Or with a line graph, could I set up a filter that makes the graph show the ten most recent days' data?

       

      Thanks