Posts Tagged ‘Essbase’

In a recent Perficient webinar, Essbase in the Cloud: A Mercer Advisors Success Story, attendees heard first-hand from Douglas Maxwell, Chief Financial Officer at Mercer Advisors about the challenges with the legacy environment as well as the Excel to cloud migration approach and benefits realized. This on-demand event is available now for download, no registration […]

Oracle Analytics Cloud Service (Essbase) has a handy command line interface that’s useful for remote execution of Essbase and system type functions such as running a backup.  This short article is simply a means to share a script that I use to run a simple Lifecycle Manager extract of one Essbase application.  This works well […]

Mercer Advisors, a privately held wealth management firm with approximately $11 billion in assets under management, needed a more robust financial reporting solution. Its legacy solution relied on an Excel-based framework with multiple General Ledger systems providing current and historical data. Mercer Advisors decided to implement Essbase Cloud, part of the Oracle Analytics Cloud (OAC) […]

“Catching up” is the term that came to mind when I used to check out what’s new with Oracle Analytics in previous years. This year, however, I frankly say I was impressed with what I saw at Oracle Open World last week. The rules of the analytics platform game have changed, tremendously. This is after […]

In one of my previous blog posts, the EPMAUTOMATE encrypt command was used to encrypt the administrator’s password on a batch script. Here, I describe the process for how to encrypt the password when used on a batch file. Before continuing, ensure the EPMAUTOMATE has been installed on the computer from which you are running […]

Amazon Web Services’ (AWS) low-cost S3 cloud storage provides a cost-efficient solution to archive snapshot files extracted from Oracle Planning and Budgeting Cloud Service (PBCS). In the following paragraphs, I will use the AWS Command Line interface (CLI) to upload to the Amazon S3 bucket to archive backup files pulled down from a PBCS instance. […]

The Essbase Block Storage (BSO) database is a powerful calculation engine capable of executing oodles of formulae with very few lines of code. But there’s a catch. You need to learn how to do it right. A poorly written calculation in an Essbase BSO cube can yield some pretty spectacular results.  Here are a few […]

I recently wrote a blog post describing the process to create and download Oracle PBCS application SnapShots to local disks. Now I’m sharing a step-by-step look at the process of importing an application onto PBCS. In this article, I will describe how to remotely execute predefined commands to upload files and migrated Artifacts SnapShot. To […]

A couple weeks ago, Oracle released Oracle Analytics Cloud (OAC). But there was already Oracle Cloud offerings for BI, mainly Business Intelligence Cloud Service (BICS) and Data Visualization Cloud Service (DVCS), so why is this new? And how is it different? Simply, OAC doesn’t abolish its predecessor Cloud BI services, but it makes them more […]

Fragmentation of Essbase block storage databases occurs as a result of routine data changes, data loads, and calculations. Essbase has two database statistics that measure database fragmentation: the average clustering ratio and the average fragmentation quotient. Check out this article from the Oracle Customer Engineering & Advocacy Lab for a more thorough description of BSO […]

The Manage Administrator Profile Values task in Setup and Maintenance is an excellent tool for troubleshooting issues throughout any of the Fusion applications. There have been several scenarios where access levels have been removed or a simple configuration may have been missing. For a majority of these scenarios, the answer was found in this task […]

When adding project details to a Purchase Order, it’s possible that the following errors may appear: These errors appear once the user attempts to save or validate the PO and also cause the PO Charge Account that was chosen for each line to disappear and become disabled. When the user goes back to review/edit the […]