Get the last 5 Days, for each Month of the Year using MDX query

In this session I'll show you how to script a query in MDX to get the last 5 days, for each month of a chosen year. After we test the query, we'll validate aggregate values for the first couple of months using a basic MDX query. [More]

Calculate Growth from Prior Period values, using the ParallelPeriod (MDX) function

In this session I'll show you how to use the ParallelPeriod function in MDX to query the change in growth between two periods (e.g., last year and current year). This function is really useful while navigating through different periods such as year, month, quarter and semester. For example, this could be useful in providing business analysts with growth trend analysis for products and/or services. [More]