ASO does not provide an out-of-the-box version of dynamic-time-series (DTS) like its partner in crime, BSO. However, one straightforward approach to achieving this functionality is to implement a time aggregation dimension and leverage MDX functionality. In this example we will house the Time Periods/Months (i.e.: Mar, Apr, May, etc.) and the Years dimensions into two separate dimensions. We then add an additional dimension called “Time Series” to the outline to support our ASO version of DTS.


