Hyperion Financial Reporting across Quarters and Years...
640678Jun 19 2008 — edited Jun 24 2008Hey All,
We’re trying to build a report that spans across 8 quarters and up to 3 years. I am sure there has to be some way to do this, but we’re having some issues on how to go about it.
If we’re in Q2 2008, we are trying to report showing data for 3 quarters going forward and 4 going back, so we’ll be displaying Q2 2007 through Q1 2009, so it’s actually spanning 3 years. We’ve been using the “Relative to Current Point of View for Period offset by 1” to calc the change for the Quarters in each column in a singular report, but can’t think of a way to change the year automatically. Currently, as soon as the period selection dictate that the columns change their display from Q4 into Q1 of the next year, Hyperion thinks we’re trying to view Q1 of the current year.
So the question is: How can we create a report that is based on Quarters that spans across another dimension?
Any thoughts on how we could accomplish this?
Thanks so much!