Falling in Love with Oracle Hyperion Calculation Manager
- Author Mike Arnoldy
- Published July 6, 2011
- Word count 447
The recent release of Hyperion 11.1.2.1 means that it is once again time to consider an upgrade of your current Hyperion application (s). For companies using older versions of Hyperion Financial Management (HFM), the EPMA and Calculation Manager platforms are topics that come up during the consideration process.
Many years ago when I first heard rumors that a GUI interface for writing rules was being developed, I was very skeptical. I knew that Hyperion’s competitors viewed the HFM rules as a weakness, wanting Hyperion to have to "show the rules" during a sales cycle. Clients I had were all excited about the possibilities of this tool. I, on the other hand, was very comfortable using VBScript. However, after working with Enterprise, I found I loved the freedom I had to do virtually anything with the HFM rules. I was able to teach accountants to understand the rules, and yes, they even learned to write rules. After this experience, I had fears that I would lose my new found freedom.
When System 11 was released, I did take advantage of several opportunities to build applications from the beginning using only calculation manager for the rules. I have to say that at first it was very, very painful. I described it as having to write rules with my hands tied—very slow and very frustrating.
I hated it… for about a week....
Then, I quickly found that I could do all of the things I could do in VBScript. At first, it took some time to discover how to do it. But literally everything I would normally put in rules—Cash Flow, USD Overrides, special consolidation rules, write to file—I could do in Calculation Manager. And, the accountants I worked with loved it.
Calculation Manager has a very nice flow chart representation of the rules. Depending upon how it is used, it breaks the rules file into individual rules. Opening up one of these rules, you see a flow chart that shows exactly what the rule is doing. Click on an object in the flow chart, and you get the details. You can even see the entire rule as VBScript. This is a great way to validate what you are building in Calculation Manager for those who are familiar with the old VBScript.
My fears over losing in System 11 what I’d gained in Enterprise were gone.
If you decide to convert to Calculation Manager, I would suggest building a separate test application to try it out, because once you upgrade an application, there is no turning back. In System 11, there are utilities that will convert your current rules. The early versions did a poor job of this conversion.
Mike Arnoldy is a senior systems architect at TopDown Consulting. He has over twenty years of experience in all phases of design, development, and implementation of financial applications, having worked at American General and Grocers Supply. He specializes in financial consolidation applications that include complex calculations, foreign currency translation, inter-company/equity eliminations and varied reporting requirements to satisfy both external and management reporting needs.
Article source: https://articlebiz.comRate article
Article comments
There are no posted comments.
Related articles
- IBM: A company that does remarkable things!
- Business Benefits of Custom Aquariums in the Workplace
- 8 Practical Tips for Raising Digitally Responsible Kids in 2024
- 2024 Food Trends: 6 Popular Low-Waste and Sustainable Recipes
- 6 Online Skill-Building Platforms to Future-Proof Your Career in 2024
- Thanksgiving and Black Friday: A Celebration of Gratitude and Festive Joy
- Lakeland, Florida: Mary Ferry Realtor
- The Significance of Move Out/In Cleaning Services in Auckland
- The Rising Demand for Car Rental with Driver Services in Kuala Lumpur
- How to Create a Safe and Stylish Baby Crib with a Bumper Crib Set
- Tesla Lemon Law
- Mary Ferry Real Estate agent in Lakeland, Florida
- Essential Marketing Strategies for Small Businesses in 2024
- Top 10 Digital Nomad Destinations for 2024 with Cost of Living Insights
- AI and Nanotechnology: How Your Smartphone Could Soon Detect Health Issues at Home
- Top Emerging Trends in Quantum Computing for 2024 and Beyond
- Luxury Chauffeur Services: A Journey of Elegance and Convenience
- What Is Harmony in Interior Design, and Why Does It Matter?
- Acura MDX and Honda Pilot: Which one will you choose?
- How to Save Money Every Day With Promo Codes
- Fresh Paint for a Fast Sale: Here's Why You Should Paint Before Listing
- The Invisible Impact of Missing Teeth: Why Replacing Them Matters
- Detecting Dental Beauty: 5 Core Traits of a Beautiful Smile
- Timeless Toothcare: Dental Hygiene Tips for Seniors
- Saving Old Smiles: How In-House Dental Discount Plans Help Seniors
- Too Much of a Good Thing? Signs You’re Brushing Your Teeth Too Hard
- Why a Root Canal Might Be the Best News for Your Tooth
- 10 Techniques for Achieving a Lean and Efficient Supply Chain
- What is DuckDuckGo?
- The Role of Lighting Stores in Brampton: Shaping Spaces for the Future