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
- Sacred Spaces in Paradise: Mogul Interior's Hand-Carved Heritage for Bahamas Wellness Resorts
- Small Space, Big Impact: POS Display Strategies That Work In Busy Hospitality Environments
- The Art of Confident Color: A Virginia Home That Celebrates Bold Design
- Pattern Alchemy: When Carved Wood Meets Brass and Bold Textiles
- Online home search portals vs. working directly with a real estate agent. What is the difference?
- Synthetic Power Steering Fluid: Why Your System Deserves Better Than Generic Options
- This Colonial Revival Mudroom Proves Practicality Can Be Stunning
- Final Fantasy I & II Premium Package (Japanese PlayStation) — Complete Collector’s Guide
- Miami Bungalow Is a Masterclass in Seaside Whimsy
- Blues That Wow: Inside an Estate Where Drama Meets Serenity
- Nintendo GameCube Official Storage Chest Station Rack Japan Collector’s Guide
- Peoria AZ Roofing Contractor – Residential Shingle Roof Specialists
- Are Smart Locks Really More Secure? Breaking Down The Myths, Risks, And Reality
- Villa Azalea: The Best Airbnb in Nagano Prefecture Japan
- A Dramatic Departure: Nantucket Retreat Trades Beach House Clichés for Moody Sophistication
- Unlock Your Dream Property: 5 States for Affordable Land and Great Value in 2026
- Sun-Soaked Sanctuary: How One Family Transformed a Dated Ranch Into an Eclectic Florida Retreat
- An Overview of the Edo Period (Era) in Japan
- Detective Conan (Case Closed) Watch Order Guide
- Becoming a Podiatrist Around the World
- Ensuring Biocompatibility: How CNC Machining Contributes To Safe Medical Implants
- The Efficiency Of Injection Molding: How It Revolutionizes Mass Production
- How to Grow Your Skills for Better Opportunities in Changing Market
- The Psychological Impacts of Bad Foot Odor
- Unlocking the Secrets of Optimal Nutrition for Growing Children.
- Smart Cities and Digital Infrastructure: Prospects for Real Estate Development in Nigeria
- Land Use Act and Its Influence on Real Estate Development Efficiency in Nigeria
- Lakeview Collection
- The Line, Saudi Arabia: Engineering Paradigms and Sustainability Challenges in Linear Urbanism
- Eudeon: Architecting Symbiotic Urbanism Through Bio-Digital Integration