I have a requirement where the Month Definition is user defined.
Part of my Time Dim looks like this :
Month Mth Start Date Mth End Date
Jan 01/01/2002 01/24/2002
Feb 01/25/2002 02/23/2002
Mar 02/24/2002 03/27/2002
So I cannot use the Standard Time dimension feature to build my Time Dimension. If I construct my time dimension and want to implement features as MTD, QTD. YTD , etc. Then the MDX Function [MTD], [QTD] etc doesn’t work.
Has anyone done any work around on this type of problem.