Tag Archives: Essbase

Fun with Oracle Analytics Cloud (OAC): Creating Essbase Cubes

August 16, 2017

Author: Andrew Tauro, Performance Architects Just like there are multiple ways to skin a cat, there’s more than one way to create an Essbase cube in Oracle Analytics Cloud (OAC) . While the best way to migrate on-premise Essbase cubes to OAC is to use the standalone “EssbaseLCMUtility” tool, to create cubes from scratch there are three ways that I have…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Important Design Considerations When Moving from Oracle Essbase On-Premise to Oracle Analytics Cloud (OAC)

July 26, 2017

 Author: Andy Tauro, Performance Architects We have witnessed a steady stream of commentary on the promise of what Oracle Analytics Cloud (OAC) , otherwise known as Essbase , BI Cloud Service , and Data Visualization (DV) in the cloud, would do when it is released, as well as where to buy a subscription. Now that OAC is generally available as a Platform as a Service (PaaS) offering, we decided to…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Oracle EPM Architect (EPMA) versus EPM Automate: What’s the Difference?

February 22, 2017

Author: Zack Carman, Performance Architects The introduction of Oracle’s Planning and Budgeting Cloud Services (PBCS) not only saw Oracle EPM’s (Hyperion’s ) introduction into the cloud but also the addition of more acronyms. One of these acronyms, EPMA, has caused confusion because this acronym describes different capabilities within PBCS versus on-premise Oracle Hyperion Planning solutions. So, what’s the difference? Enterprise Performance Management Architect (EPMA) is an on-premise component that is…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Preventing Oracle Planning and Budgeting Cloud Service (PBCS) Data Load Errors Before They Happen

February 15, 2017

Author: Richard Pallotta, Performance Architects We recently worked with a client to migrate their on-premise Oracle Hyperion Planning application to Oracle Planning and Budgeting Cloud Service (PBCS) . Over the years, they developed a supporting infrastructure of business processes that worked well for them. Our concern was to mitigate any disruptive process changes that could result from the transition and pose risks to a successful…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Replicating On-Premise Essbase Load Rules in Oracle Planning and Budgeting Cloud Service (PBCS) Using Data Management

December 14, 2016

Authors: Mohan Chanila and Tyler Feddersen, Performance Architects One of the perceived issues with the release of Oracle Planning and Budgeting Cloud Service ( PBCS ) in 2014 was the lack of full-use Essbase in the cloud.  With this, the ability to use load rules to modify, edit, and prepare a data file to upload into the cloud was taken away, and the PBCS interface…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

How to Generate, Populate and Integrate an Essbase Cube into an OBIEE 12c Environment Using the Essbase Business Intelligence Acceleration Wizard

August 17, 2016

Author: Doug Ross, Performance Architects One of the lesser known and (mostly) undocumented features of Oracle Business Intelligence Enterprise Edition (OBIEE) 12c is the Essbase Business Intelligence Acceleration Wizard.  This new component provides a very simple way to generate, populate, and integrate an Essbase cube into an OBIEE environment to boost query performance through aggregate redirection.  Utilizing the Essbase server that can be…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Limiting Oracle Essbase Data Loads to Level 0 (Leaf) Members

August 14, 2015

Author: Andy Tauro, Performance Architects Recently somebody asked me, “Is there a way to limit data loads to Oracle Essbase databases to ensure that only Level 0 or leaf members are loaded?” Essbase itself does not have a constraint that will disallow a user from loading data to a non-leaf member, assuming that the said user has…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Five Themes and Outcomes from the Higher Education Data Warehousing (HEDW) Conference

April 27, 2015

The Higher Education Data Warehousing Forum (HEDW) , “a network of higher education colleagues dedicated to promoting the sharing of knowledge and best practices regarding knowledge management in colleges and universities, including building data warehouses, developing institutional reporting strategies, and providing decision support,” hosts an annual conference every year for networking and knowledge-sharing purposes.  The event is comprised of training sessions, presentations by universities and select vendors, and…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Oracle EPM (Hyperion) Version 11.1.2.4 Launch: Oracle Hyperion Financial Management (HFM) Profile Editor

February 10, 2015

Oracle Hyperion Financial Management (HFM) was re-launched as a multi-platform product in the recent Oracle Enterprise Performance Management (EPM or Hyperion) Version 11.1.2.4 release.  One of the long-awaited enhancements in this release is the creation of application profiles. Application profiles define the core characteristics of an HFM application, such as the languages and calendar it uses, as well as custom dimensions (since Version 11.1.2.3). However, until 11.1.2.4, application profiles…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Oracle EPM (Hyperion) Version 11.1.2.4 Launch: Interface Enhancements

February 9, 2015

As you may have heard, Oracle just released Enterprise Performance Management (EPM or Hyperion) Version 11.1.2.4 . You may say, “Big deal, don’t they come out with a new release at least every year?” Actually, this happens to be the first new major release in two calendar years. In calendar year 2014, we saw the release of Patch Set Update (PSU) 500 for…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.