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

Clueless Guide: Difference between BI Reports and ERP Reports

Business Intelligence (BI) is just a fancy term for reporting. If I ask a business user what a report is, he/she will be able to bring up an image in their head of what it is and explain it as well. To make it easier to understand BI, just consider it as a reporting mechanism. That begs to the question why we have a fancy term like BI for a simple concept like reports?

Continue reading

ETL Tools

As a consultant I am usually making recommendations to customers for processes and products. On a recent discussion with a client (a major bank) I was basically working out an enterprise architecture to support their reporting requirements. In a move to consolidate its operations and personnel the bank has made a central body to take charge of ALL reporting requirements of the organization locally as well as globally.
Continue reading