O'Reilly logo

Oracle Hyperion Financial Management Tips & Techniques by Peter Fugere

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Best Practices for Reports

There are some good practices to follow when writing reports. It starts back when you created your design. You should be thinking of the reports you want constantly through the design process. You need to design your application to support the reports rather than the reverse. When you build structures and hierarchies, they should support the reports you need. Your totals and subtotals should be parent members in these structures. You want to build calculations in the system that support the reports. Why have the report calculate a simple ratio every time it is run, when you can build that in the database and calculate it one time when you consolidate? Think about it like this: What is easier to pull, one number or two ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required