TopDown Blog

Tag: Essbase Studio

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…

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…

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…

ODI—What Now?

By on April 6th, 2011

Have ODI, will…   Many companies are struggling to embrace the new Hyperion software products Oracle releases each year. The current “Information Now” age has created a need for supporting technologies, and Oracle has been quick to respond. Oracle Data Integrator (a.k.a. “ODI”) is one of these technologies. Introduced a few years ago, Oracle acquired…

Rapid Data Prototyping Using a Relational Database

By on March 30th, 2011

Most companies implementing an EPM, consolidation or reporting system will need to bring together metadata and data from several different sources. These sources will likely have been developed at different times using different technologies with different intentions. Each of these factors will have contributed to there being differences in the hierarchies available in each system,…

Transitioning, Mapping, Validation – Make Your Database Work for You

By on February 22nd, 2011

Every company that moves between systems in an effort to modernize—e.g., moving from Hyperion Enterprise to Oracle Hyperion Financial Management (HFM)—must validate their data. This process is often made more complicated by differences in hierarchies, the inclusion of additional data sources, changes required to utilize additional capabilities in the new tool. In addition, transitioning from…

Remote EPM development—Managing a Global Development Effort

By on January 24th, 2011

I spend most of my time these days on engagements with multi-national organizations that, of course, are implementing a global enterprise performance management system. One very common challenge is how to include system administrators from other regions, continents, and time zones. At TopDown we stress knowledge sharing by having our clients work alongside our consultants…

How to Leverage Existing Database Technologies for Successful EPM Implementations

By on January 18th, 2011

In planning for an EPM project, companies need to consider many different factors, the first being the tool selection process. Now many companies know they must go through a tool selection process when undergoing a project addressing a business problem as important as EPM. This often involves a careful review of what tools are out…

© Copyright 2020 TopDown Consulting. All Rights Reserved.