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
- Lotus Carved Decorative Doors
- Where Your Donation Matters Most: Helping the Poor with Medical Care and Animal Welfare in India
- How Sponsoring Elderly Care in India Creates Lasting Social Impact
- Motorcycle Accidents in Hattiesburg: Mississippi's Pure Comparative Fault Advantage and How It Protects Injured Riders
- Dog Bite Injuries in Colorado: How the Strict Liability Statute Works and What Injured Victims Can Recover
- Truck Accident Claims in Green Bay: How Local Industries Shape Liability
- Dog Bites in San Luis Obispo: California's Strict Liability & What It Means for Victims
- How the Region's Paper and Food Processing Industries Shape the Commercial Vehicle Liability Landscape
- Colorado Dog Bite Injury Claims and What the State's Strict Liability Law Means for Victims
- THE QUIET GRANDEUR: VINTAGE CARVED ARMOIRES FROM MOGUL INTERIOR
- Wellness by Design: Nature's Harmony in Carved Wood Doors
- Why People With Diabetes Need to Take Special Care of Their Feet
- Calcaneodynia: Understanding Heel Pain
- Collected & Crafted: A Modern Farmhouse That Tells the World's Most Beautiful Stories
- Why Winter Is Actually the Best Time to Visit Sydney
- Ireland Sino Institute Secures Media Partnership with CCTV+
- What Is Rubbish Removal? A Simple Guide for Beginners
- Eclectic Maximalist Farmhouse Style – Vintage Armoires, Sideboards & Coffee Tables That Tell a Story
- Unique, One-of-a-Kind Statement Armoires – Farmhouse Style Large Cabinets with Free Shipping from Florida
- Treatment of Sesamoditis in the Foot
- Marketing Strategies for a Dog Daycare
- Clarity Is What Makes You Usable
- Transparent Champagne Glass Set of 6 (200ml): A Premium Choice for Modern Celebrations by Black Carrot
- Orrell Park Pharmacy & Vaccination Centre - Travel Clinic
- How To Achieve Safe Suntanning and Best Bronze Glow
- The Power of Free: Unlocking Self-Improvement and Success Without Spending a Dollar.
- China Internship Programme: An Overview of Module 1
- How End Of Arm Tooling (EOAT) Enhances Productivity And Quality In Automotive Plastics
- Why Mogul Interior's Handcrafted Carved Doors Are in a League of Their Own
- The Sacred Threshold: Antique Carved Doors and the Art of the Meaningful Entryway