Essbase Articles - Perficient Blogs
Blog

Posts Tagged ‘Essbase’

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Oracle Autonomous Analytics BI Admin Tool – Essbase Error 1040048

Oracle Autonomous Analytics Cloud BI Admin Tool is similar to the BI Admin tool. You can download the tool from the following link: https://www.oracle.com/technetwork/middleware/oac/downloads/oac-tools-4392272.html When you try to establish the connection to Essbase Cube for import using this tool, you might get the following error: Essbase Error 1040048: HTTP communication failed with error [Failed to […]

Read more

Customizing Oracle EPM Workspace Logon Page for 11.1.2.4 Part I

It is very important for users to identify to which environments are they logging in. For this reason, I am sharing the following insights into how to customize the Oracle EPM workspace logo, which will help users determine if they are logging into a Production, Development, or QA environment. Out of the box Workspace log […]

Read more

Oracle EPM Automate Tool – Installation Procedure

About EPM Automate EPM Automate Utility enables Service Administrators to automate many repeatable tasks,  including the following: Import and export metadata, data, artifact and application snapshots, templates, and Data Management mappings Upload files into environments, list files, and delete files from the service Download snapshots, reports, and metadata and data files from the service Run business rules on data, and […]

Read more

Five Tips for Creating New OACS Instances

Five Tips for Creating New Oracle Analytics Cloud Services (OACS) Instances Recently, I have been assisting customers with creating new Oracle PaaS instances – specifically OACS – and I have come up with a few tips for those new to the process. Tip #1:  Keep a copy of the certificate pair you generate. PaaS instances […]

Read more

Migrating Essbase Cubes to Oracle Analytics Cloud

With the shift to the cloud, on-premises Essbase applications may be migrated to Oracle Analytics Cloud (OAC) using a simple method provided by Oracle. Essbase Life Cycle Management process is cost effective and easy to use utility for EPM Professional or Technical lead to migrate the applications to the cloud without the need of recreating […]

Read more

Essbase in the Cloud [Webinar Q&A]

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

Read more

One script to back up your OACS Essbase Application

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

Read more

Mercer Advisors Presents – Oracle Essbase in the Cloud [Webinar]

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

Subscribe to the Weekly Blog Digest:

Sign Up