
I am trying to create a report that will automatically provide a rolling P&L for the current reporting period and the past 13 months (Current Month, Current Year to Current Month Prior Year. During the month of December 2014 we were required to create a 13th period for Hyperion reporting. Also for the GP Year of 2015 we were required to use only the month of January to switch from a standard fiscal year to a February to January fiscal year. However, this has created issues for reporting out of MR.
For the Column Definition I have my Base Year set to "BASE" for all 14 columns and my Period set to "BASE", "BASE-1", "BASE-2", etc. MR will pick up the correct period and year for all designated periods except for the second half of December (Period 13). A blank column is the only thing that is provided.
Is there any thing I can do to avoid having to change my column definitions every month?
*This post is locked for comments
I have the same question (1)