Many folks have a bit of trouble getting their arms around the Essbase Block Storage Calculation Script syntax – especially if they have spent time previously working in relational databases. Essbase BSO calculation syntax looks nothing like structured query language. In the Essbase Bootcamp and the Essbase Calculations for Block Storage Databases classes, I will […]
Posts Tagged ‘Essbase’
Integrating OBIEE with Essbase for an Executive Mobile Dashboard
Client Headquartered in Denton, TX, Sally Beauty is an international specialty retailer and distributor of professional beauty supplies with revenues of more than U.S. $2.6 billion annually. Through the Sally Beauty Supply and Beauty Systems Group businesses, the company sells and distributes to more than 4,000 stores, including approximately 200 franchised units, throughout the United States, […]
Improved Financial Management Reporting: CFO’s Vision Needed
The management reporting processes at various companies have significant limitations in meeting key expectations. Typical shortcomings are across three areas: * Impactful and timely reporting that forms the basis for proper decision making * Advanced analysis of the latest business metrics and future trends * Accurate business forecast to allow for effective planning This is […]
Corporate Allocations: Allocating Your Way to Value and Profit
In today’s corporate America few executives and finance leaders fully grasp the benefits of developing an effective and streamlined corporate cost allocation process. Corporate allocations, when implemented correctly, can provide tremendous insights into the profitability of business segments, customers, and products. This knowledge can then help business unit leaders realign resources within the company, thereby […]
Dynamic Member Creation in Hyperion Planning
For this new blog post, I am excited to tell you about one of my favorite features: Dynamic Member Creation. Beginning with Hyperion Enterprise Performance Management (EPM) release 11.1.2.3, Dynamic Member Creation is available in pre-delivered plan types such as Project Financial Planning, Public Sector Planning and Budgeting; and as part of the core Planning […]
6 Tips and Tricks-FDMEE Integration with Oracle E-Business Suite
Financial Data Quality Management Enterprise Edition (FDMEE) is Oracle’s strategic product for integrating ERP systems with Oracle’s Hyperion EPM applications. It provides seamless integration of both master data and data between major ERP systems such as E-Business Suite, PeopleSoft GL, SAP and Hyperion EPM applications. See the architecture diagram below: […]
Migrating On-Premises Planning Application to PBCS
Are you currently thinking about migrating your existing on-premises Hyperion Planning application to the Cloud? Are you having reservations about what this process may entail? Well put your reservations aside! Oracle Planning and Budgeting Cloud Service (PBCS) makes the migration easy as it essentially has the same code base as on-premises Hyperion Planning release […]
Essbase Errors & Resolutions
Like many of us, I have run into several essbase errors while creating/testing/implementing new applications and scripts. Some of the errors have useful information in the log files or the error code’s description clearly reveals where the error lies, but there are those codes which provide little to no information or the accompanying error message […]
How to Apply OBIEE Data Level Security against Essbase?
Over the last few years the integration between Oracle Business Intelligence Enterprise Edition (OBIEE) and Essbase has been undergoing continuous evolution. The progression is aimed at making both analytical products more compatible as they are complimentary. Security may be a challenge, however, when it comes to implementing data-level security on OBIEE reports that source data […]
Modern Budgeting & Forecasting Has Arrived – Are you Ready?
The recent departure of Walgreen’s CFO due to a large forecasting variance error, is a drastic reminder to all of us who have dedicated their careers to financial transformation, of the intense criticality of mastering the entire cycle of planning, budgeting, forecasting and reporting. 15 years ago when I started consulting with finance and accounting […]
Using @XWrite vs @XRef Functions
The Situation: Planning 11.1.2.1 Client has two Plan types (Finance & FTE) Detail employee data is held in the FTE cube and summary employee data is held in the Finance cube Requirement: Move data from FTE cube to Finance cube at the summary level as efficiently as possible. Solution: The @XWRITE function does just what […]
Creating Essbase Data Backups with Data & Time Stamps
Creating Essbase Data Backups with Filename Date & Time Stamps The Situation: Planning 11.1.2.1 Client has 1 application with 3 databases Requirement: Automate a daily backups of the Essbase data for all three cubes at 7am and 7pm. Solution: Used MAXL script to export the data from essbase Batch file to execute MAXL script and […]