EPBCS ASO Dynamic Time Series
Summary
EPBCS ASO - Unable to add Dynamic alternate hierarchy in Period dimensionContent
As we know, there is no out-of-box Dynamic Time Series feature for ASO cubes (Premise or Cloud). On of the workaround solutions is to have an alternate Period/Time dimension hierarchy which leverage MDX formulas to have this feature. This is less popular but only approach if an additional dimension is not desired.
Unfortunately, we are facing issues with implementing this for our EPBCS ASO plan type. Upon adding a dynamic hierarchy (enabled only for the ASO plan type), the Essbase refresh fails with the following error:
0