In the recipe Calculating the YoY (Year-over-Year) growth (parallel periods) we've shown how the
ParallelPeriod() function works and how it can be used to calculate the YoY growth. All we had to do is specify a member, ancestor's level, and an offset, and the parallel member was returned as a result.
OLAP works in discrete space and therefore many functions,
ParallelPeriod() included, expect a single member as their argument. On the other hand, relational reports are almost always designed using a date range, with Date1 and Date2 parameters for that report. As the relational reporting has a longer tradition than multidimensional, people are used to thinking that way. They expect many multidimensional ...