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.
Hi Dave. You still working on this issue? I just have a few questions. Do you have access to build calculations in your cube? Do your end users typically want to views just a few days from a start date? Can you provide a days-range (last 10, 30, 60 days for example)? And what type of visual are you trying to build...trending or simple text chart?