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://art.xingliano.comRate article
Article comments
There are no posted comments.
Related articles
- What is Fly Fishing?
- Minimalist or Statement Sliding Barn Door: Which Is Right for Your Space
- How to Style Antique Indian Armoires & Sideboards in a Modern Home
- Custom Antique Doors: How Mogul Interior Sizes Vintage Doors to Fit Any Space
- Personalized Dining Experiences: How AI POS Systems Learn Your Customers’ Preferences
- Perth Is One of Australia's Fastest Growing Cities. Here Is What That Looks Like on the Ground
- Ireland–China Relations: A Century Built on Exchange and Understanding
- Mindfulness: Living in Harmony with the Elements
- Lash Extension Aftercare Starts With Proper Removal
- How Lash Techs Can Make Removal Appointments More Comfortable
- Electric And Hybrid Car Leasing: The Smart Move For 2026
- What Clients Should Know Before a Lash Extension Removal Appointment
- Common Lash Removal Mistakes New Lash Techs Should Avoid
- Lash Remover Cream vs. Liquid Remover: What Lash Techs Should Know
- Common Lash Removal Mistakes New Lash Techs Should Avoid
- Lash Remover Cream vs. Liquid Remover: What Lash Techs Should Know
- Common Eyebrow Tint Mistakes and How to Avoid Them
- Outdoor Makeup Tips for Hot Days: What to Keep Simple Around the Eyes
- How to Choose the Right Brow Tint Shade for a Natural Look
- Best Eye Makeup Ideas for Summer Travel and Weekend Trips
- Magnetic Lashes vs. Strip Lashes: Which Is Easier for Beginners?
- Lotus Carved Decorative Doors
- Where Your Donation Matters Most: Helping the Poor with Medical Care and Animal Welfare in India
- Solutions For Clinical Trials
- 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