TopDown Blog

Tag: Essbase Cube

Date with Essbase Member Formulas

By on February 22nd, 2012

One of the common functions in any Database or Spreadsheet program is manipulating Day/Date functions to drive financial calculations or use calendars to organize and report periodic data. Unfortunately, this, like many functions, does not come natively in Essbase or any OLAP-based application and requires a bit of coding. Essbase database cannot store non-numeric values…

Fish Out of Water: New Essbase Functions

By on February 15th, 2012

I was reading a story about someone trying to clean out his little fish bowl, which held a bunch of fish. He emptied the fish into a bathtub full of water so he can clean up the bowl, and then noticed that the fish remained bunched up together in a circle, not venturing out.And  This…

Allocations, Activity Based Costing and Essbase Functions

By on February 1st, 2012

One of the prevalent Costing models, primarily used in manufacturing is Activity-based Costing. Activity-based Costing or ABC gained popularity as Overhead and Indirect Costs were scrutinized by management, production lines became more complex, and cost center managers were held more accountable for detailed product P&L’s and overhead cost controls.  Traditionally, a fixed percentage was applied…

Time Travel with Essbase

By on January 26th, 2012

I was reading the biography of Albert Einstein—the most fascinating pieces are on how he developed some of his greatest theories by observing his natural surroundings.  In one experiment, performed in his head rather than in a lab, he challenged Isaac Newton’s concept of space and time, in what eventually would become the Special theory…

Workforce Planning, Is It Right For Me?

By on January 18th, 2012

Considering Hyperion Planning for Budgeting but still have to manually plan employee salaries and benefits?  Do economic conditions require you to constantly revise Headcount planning in your organization?  Do you want out-of-box solution with pre-built Logic, Web forms and calculations for Planning Salaries, Merit Pay, Bonus and Tax? Do you have a limited budget and/or…

An Essbase Cube for Increasing Network Quality at a Wireless Switch Station

By on August 24th, 2011

At a recent client, the project team had the task of reviewing an Essbase database application that provided analysis on network quality at a wireless switch station. Upon review, the team discovered that we could optimize the Essbase cube to load raw data from base stations at a faster load rate. The new reporting cube allowed…

Essbase Training – the Little Things

By on July 12th, 2011

I just came back from a two week, around-the-world training engagement where I was part of a team that presented a class on how to use SmartView and Financial Reports to retrieve information from Essbase. The class was a success, and the users all appeared to understand the material we covered. However, as I listened…

Oracle Hyperion 11.1.2.1 migration features and hiccups

By on June 21st, 2011

Oracle Hyperion 11.1.2.1 includes new tools that will ease migration, cutting down on the number of steps needed in many cases. However, there are still some issues, such as with Essbase Studio, that should be fixed in future versions….[more] This article first appeared in SearchOracle.com. To view the full article, visit http://bit.ly/jFA3nK (requires free membership…

Using Planning Currency Conversion Feature to Manage Foreign Currency Exposure

By on June 1st, 2011

A typical challenge for any company that transacts business in a number of currencies is how to reduce the impact of foreign currency fluctuation on its bottom line. Overcoming this challenge requires maximum insight into a company’s FX needs and timing of such needs. Gaining such insight is less of a challenge if a company…

Using Essbase API, Excel VBA, and ODBC to Get Transaction Level Data

By on May 18th, 2011

  Hyperion Essbase has this cool tool called Drill-Through Reports that allows you to drill into leaf level data in the cube. The tool comes standard with Version 9 and above. Users love drill-through because it is a natural extension of the process of analysis. After a balance has been identified, drill-through allows the user…

© Copyright 2020 TopDown Consulting. All Rights Reserved.