Time calculations in UDM: Parallel Period (by Mosha Pasumansky)
Information on how to handle parallel periods with time intelligence, Also Expands on paper "A different approach implementing A Different Approach to Implementing Time Calculations in SSAS by David Shroyer.
Comparing current data to the data in the same unit (day, month, week) in the previous period (year, quarter, semester) is one of the most fundamental tasks in the OLAP system. In MDX this is usually archived through the ParallelPeriod function. However, the classic approach to ParallelPeriod doesn't work well in UDM where Time dimension has many attributes and hierarchies, and where symmetric hierarchy structure is hard to achieve across Calendar, Fiscal and other hierarchies. Time Intelligence wizard doesn't address all these issues either. In this article we will discuss strategies how to build MDX Script calculations for parallel period to work properly across all attributes and hierarchies.
Tags: time dimension