Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rolling quarterly report

Status
Not open for further replies.

maddyyikes

IS-IT--Management
Jul 19, 2004
32
US
Hi,

I am new to BO and am trying to generate a rolling quarterly report. The universe has a fiscal year and fiscal quarter field (values 1,2,3,4). I would like to know as to how I can generate the current and prior quarters within the cross tab report relative to the current day? Also, when the year changes to a new one it may be required to compare the current year's first quarter with the last quarter of the previous year and the fiscal quarter may not work in this case since it's values run from 1-4 for each year. Any ideas around this?

Thanks in advance
 
The reality is that this isn't a BO question at all.

Ask yourself how you would do this in SQL. When you get that answer, then you need to implement the same thing in Business Objects.

This is best done at the universe level and usually requires some very intelligent calendar methods.

Steve Krandel
Intuit
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top