Tag Archives: Block Storage Option (BSO)

Defining Essbase Storage Options: ASO Versus BSO

September 20, 2017

Authors: Warren Pereira and Andrew Tauro, Performance Architects Oracle’s Essbase is a popular multidimensional database platform that powers business analytics solutions the world over, both on-premise and as Software-as-a-Service (SaaS, in the “cloud”). The name stands for “Extensible Spreadsheet Database” because this database’s dimensions provide multiple views of a dataset, and you can drive complex calculations off…   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.

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.

Clearing Data in the Oracle Planning and Budgeting Cloud Service (PBCS) Simplified Interface

March 22, 2017

Author: Ben Hogle, Performance Architects If you’ve ever loaded data into Oracle Planning and Budgeting Cloud Service (PBCS) , you’ve almost inevitably had to clear data from your ASO and/or BSO cubes. Maybe you goofed, maybe something changed; it doesn’t matter, your data must be purged and reloaded; and the ability to clear large amounts of data relatively easy is a life…   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.

Why an Operational Data Store (ODS) Provides Important Capabilities in an Analytic Architecture

March 5, 2014

The Operational Data Store (ODS) concept is a viable architectural option when considering complex requirements that deal with data transformation and mapping logic for large data sets.  At times, data feeds from multiple source systems require manipulation through the use of various reference data that may exist either as look-up tables or master data tables residing within the repositories…   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.