Daily Archives: January 5, 2011

MDX Solution for ParallelPeriod Issue with Uneven Periods

I have a client that had a period in 2009 with 34 days and the same period in 2010 with 39 days. Therefore, the ParallelPeriod function was returning null when attempting to pull any year over year comparisons for days past 34. The Time dimension has a Fiscal calendar hierarchy with levels for Year, Quarter, Period and Actual Date.

Posted in Business Intelligence | Tagged , , | Leave a comment