1 Reply Latest reply on Jul 5, 2011 8:24 AM by Ed Egan

    Creating Dynamic Date Sets with a parameter and SSAS

    Dave Belue

      I'm trying to create dynamic Date set from date dimension that include the normal SSAS Sales Date hierarchy (Year, Quarter, Month, Date) and two parameters that capture a start date and number of reporting days going forward. The goal is to use this set in a filter so the users can select the days to report on.  But, Tableau works much differently with SSAS than with excel or relational data source.  The problem I'm having is when building the formula in the Set it doesn't give me the dimensions to use in the formula, only the measures, so I can't build the date logic for the set.  Any help or work arounds on this would be greatly appreciated.

       

      Thanks,

      Dave