Adhoc Analysis within Hyperion Planning

I was trying to be creative and think up of ways to show the analytical capabilities of the Hyperion Planning system to demonstrate to a client (who had strongly suggested that these capabilities would play a very important role in their evaluation of a budgeting and planning solution) and came up with one approach that I’d like to share here.
Continue reading

Cognos TM1

IBM Cognos TM1 is enterprise planning software used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Similar to Hyperion Essbase, TM1 is a multidimensional data store however it only supports data storage at the “leaf” level.

Having worked with Hyperion Planning solution, I decided to explore the Cognos TM1 offering. The latest version is 9.5 which came out February 9, 2010 and there has been some considerable improvements – the most visible being TM1 Contributor which is a web-based front end. Previously TM1 was basically managed through the Microsoft Excel interface and the TM1 Architect.

In the subsequent posts I will be taking a look at the Cognos TM1 version 9.5 offering starting with the installation.

Automate Essbase Data Backup with ESSCMD and BAT

Backup! Backup! Backup!

The three most important aspects of managing an enterprise application as explained to me by one of the key personnel for the current client I’m working for. She hasn’t failed to stress enough, the need to ensure timely and complete backups.

Continue reading

Hyperion Financial Data Quality Management (aka FDQM)

Oracle Hyperion Financial Data Quality Management is a packaged solution for finance users that helps develop standardized financial data management processes with its Web-based guided workflow user interface. Its data preparation server can ease integrating and validating financial data from any of your source systems. And to further reduce your data integration costs as well as data mapping complexities, Oracle Hyperion Financial Data Quality Management includes prepackaged adapters for Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle Hyperion Strategic Finance, Oracle’s Hyperion Enterprise, Oracle Essbase, and Oracle E-Business Suite.

Continue reading

Limitations on size of dense dimensions for optimum performance

Designing an Essbase DB comes with a lot of practice and experience. There are however some basic tips & tricks that we should be aware of. One common question I’ve come across in my inbox relates to the ideal block size of an Essbase DB.

Continue reading

Hyperion: Why is there a startup order for the services?

I’ve often been asked this question from people who are new to Hyperion. To best understand the reason behind the specific sequence in which the Hyperion services are started we must understand the architecture of the product suite.
Continue reading

Release: Hyperion Planning – System 9 Installation Guide

Hi All,

This has been a long time coming and I apologise for the delay. This document primarily got delayed because I got really busy with a couple of projects and had absolutely no time available. Well, here is the document and I hope it helps out those who are new to Hyperion Planning – System 9. If some of you have experience with this and feel that I missed out on any key details or if there is any change you would like to see in guide then please do feel free to email me and let me know. The comments section on this post will be closely followed for the same.

Continue reading