Posts Tagged ‘Essbase’

5 Oracle Analytics Trends to Watch Out for Starting Now

“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 […]

How to Encrypt the Admin Password When Used on a Batch Script

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 […]

Archive PBCS Snapshots to Amazon S3 Cloud Storage

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. […]

Improve Your Essbase Calculation Capability

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 […]

How to Restore PBCS Application Artifacts and Data from Snapshot

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 […]

Oracle Analytics Cloud: Essbase and Many Other Interesting Things

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 […]

How to Monitor Essbase Database Fragmentation

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 […]

Manage Administrator Profile Values: Troubleshooting in Fusion

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 […]

Solution to Account (PO var/charge) Could Not Be Determined Error

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 […]

A Logical Solution to Financial Reporting Using OBIEE and Essbase

Effective and efficient financial reporting is crucial for the success of semiconductor companies.  It is critical to track revenue, shipments, and order backlogs in order to properly utilize company assets.  In addition to understanding the current financial position of the company, there needs to be visibility into company forecasts in order to do proper financial and manufacturing planning. Data […]

Expenses Flow to Payables: Fusion iExpenses

The Oracle Internet Expenses application has quickly become one of the most intuitive products in the Financials suite. Not only have I previously discussed how simple it is to use the mobile app or how simple it is to create an expense report in the instance, but the seamless flow to Payables is definitely worth […]

Workaround for AR Transactions LOV Missing

In regard to the example I gave of AR transactions not functioning in last week’s blog, there is a simple fix. This is not something that my team discovered on Oracle Support or through Google, but it’s something that was discovered when looking at roles. The AR roles on the role template for the “Receivables […]

Load More