Posts Tagged ‘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 […]

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

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

Recently at a customer site we saw the following issue with a user trying to run a FR report. The user was unable to run a report or connect to Smart view via an Essbase connection. However, the user could enter data using planning web forms. The user was getting the following error, “Cannot open […]

When it comes to choosing the right Cloud BI platform, there is usually a trade off between governance and centralization on one hand and agility on the other. BI software vendors like Tableau and Qlik, that are relatively newer to the game than traditional BI platforms, have changed the rules of what defines a better BI […]

“The CPM suite market is shifting toward cloud-based solutions that deliver a shorter time to value and improved ease of use.” – Gartner If there’s any doubt that corporate performance management (AKA enterprise performance management, or EPM) has a future in the cloud, think again. Most of the buzz from industry and corporate events has […]

Gone are the days when several spreadsheets, pen and paper, and calculators are needed to reconcile financial reports. A common challenge in financial reporting is validating that what gets reported on executive dashboards matches with more detailed financial statements and transaction level reporting. What aggravates this endeavor is the fact that executive level dashboards are […]

Many of us may have used SET DATAEXPORTOPTIONS. But I noticed that there are some glitches in that command usage that is not documented explicitly. It can cause a “LOT” of trouble with respect to performance. I spent few hours on this and thought will share it with you all to save some time. However, […]

Interested to get a closer look at how quick-to-deploy and scale-able Oracle BI Cloud Service is? Meet us at Oracle Open World on Oct 29th, for a best practices and case study of CPI Card Group, a leading provider in payment card production and services. Tyler Wilson of CPI Card Group will join me in telling […]

Recovery of data in Essbase is sometimes confusing and time consuming depending on the type and frequency of backups previously taken. In this article, I’ll give you an idea of how you can back up your Essbase data for the purpose of restoring a slice of the database. Scenario: I am running a daily export […]

Essbase does its best to be friendly to us system admin types, but sometimes I just want to scratch my head in bewilderment. In 11.1.2.3 and later, Essbase performs a backup of the Essbase.sec file every 300 seconds and retains a default of two backups. This means that at any given time, you have two […]

In Essbase 11.1.2.2, Oracle added a configuration option to improve the performance of Essbase Block Storage database restructures. RESTRUCTURETHREADS is a setting you can add to your Essbase.cfg file to enable parallel restructure of BSO databases. The proper syntax taken from the Essbase Technical Reference is: RESTRUCTURETHREADS [ appname [ dbname] ] n Application and […]