How to break the time hierarchy for financial reporting? -
08-04-2003
, 09:56 AM
I have a dummy dimension used only of calculated members, like
[Analysis].&[1]. Now I will like to create a broken time hierarchy with a
group of few members like LastNonEmptyMonth, TheSameMonthPreviousYear,
LastYearsLastMonth,ThisYearLastMonth(for Budget). I will like these groups
to be dynamic depending on the LastNonEmptyMonth. If my Last month with is
July 2003 I will like July 2002, December 2002 and December 2003.
How do I combine these dynamic time members with my Analysis/Dummy dimension
to make this work.
I have scanned George Spoffords book and Tom Chesters site without finding
any information or examples regarding this.
Any hints, suggestion is appreciated.
/Thomas Ivarsson |