Finding Last n members of a Particular month of a particular Year from a Time Dimension using MDX
Suppose we have a Time Dimension where we have four attributes:
Year, Month, Day and PeriodKey
Now we create a hierarchy using these attributes. Creating a Time dimension hierarchy is a little bit tricky. The following link shows a detailed method of how we can create a Time Dimension and hierarchy.
Period Dimension (Time Dimension) Creation with Year, Month, Day Hierarchy
Tags: mdx, time dimension