Category Archives: Technical

How to Implement Transparent Data Encryption (TDE) in an Oracle Database

November 15, 2017

Author: Cameron Ross, Performance Architects The reason for using Oracle Transparent Data Encryption Oracle (TDE) column encryption is to protect confidential data, such as credit card and social security numbers, stored in table columns. TDE column encryption encrypts and decrypts data transparently when data passes through the SQL layer with no modification required to any existing application. The first step 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.

Renaming Presentation Tables in OBIEE 12c

November 8, 2017

Author: Linda Stewart, Performance Architects Today I was working in an Oracle Business Intelligence Enterprise Edition (OBIEE) 12c RPD (Version 12.2.1.2, the on-premise Oracle BI solution) and I dragged my table from the logical level to the presentation level.  I wanted to rename the table, but the name in the property sheet was locked. The solution is to set a property in…   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 Modify the OBIEE Error Message

November 1, 2017

Author: Cameron Ross, Performance Architects The Oracle Business Intelligence Enterprise Edition (OBIEE) error message can be a very daunting alert for an end user to receive. This message can be edited in order to change the display. The standard Oracle error message contains three content objects: 1. The title; 2. The subtitle; and 3. Error details.  The steps below outline how…   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.

Using an Excel Spreadsheet as a DV Desktop Data Source

October 25, 2017

Author: Cameron Ross, Performance Architects Oracle Data Visualization (DV) Desktop allows you to bring in your own data from an Excel file and to use this data as a source for visualizations.  In this case, I compiled a basic spreadsheet of sample Major League Baseball (MLB) attendance data. I uploaded this content to DV Desktop and created visualizations using the…   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.

Patching Essbase in OAC to 17.3.3-926 with Oracle 11g RDBMS

October 18, 2017

Author: Andy Tauro, Performance Architects I recently applied the 17.3.3-926 patch to Oracle Essbase Cloud Service (ESSCS) in Oracle Analytics Cloud (OAC ). If you have not patched OAC yet, the good news is that this process is as close to “one-click” as it can get, with the capability to perform a “pre-check” of the instance (and while we have yet to see this fail,…   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.

Updating Oracle EPM (Hyperion) for Struts RCE Vulnerability

October 11, 2017

Author: Andy Tauro, Performance Architects It is hard to not have heard of the Apache Struts vulnerability that affected major websites, including those of Equifax. When this happened, IT support teams scrambled to check their environments and to apply fixes as quickly as they could be found. Our customers running Oracle EPM (Hyperion) (as well as Oracle Business Intelligence Enterprise Edition or OBIEE ) on-premise inquired…   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 Essbase On-Premise versus Oracle Essbase Cloud Service

October 4, 2017

Author: Andrew Tauro, Performance Architects By now you have most likely seen a lot of material (including posts on our blog ) regarding how Essbase has moved to the cloud as Essbase Cloud Service (ESSCS) , which is part of the new Oracle Analytics Cloud (OAC). You may still be wondering how the feature sets between the two versions of Essbase…   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 Create a Data Source in Oracle Enterprise Performance Reporting Cloud Service (EPRCS)

September 27, 2017

Author: Mike McClean, Performance Architects Oracle Enterprise Performance Reporting Cloud Service (EPRCS) provides a solution whereby organizations can combine narrative along with management financial reporting in order to explain results.  It allows various contributors to collaborate across multiple sources and locations. One of the features in EPRCS is the ability to pull in data from other Oracle -supported cloud solutions.  This is accomplished…   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.

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.

Customer Case Study: How to Implement Revenue Recognition in Oracle Hyperion Planning or PBCS

August 30, 2017

Author: Tony Tauro, Performance Architects In a previous blog post , we took a high-level look at the basic principles behind the revenue recognition concept. In this post, we demonstrate how to implement revenue recognition in an Oracle Hyperion Planning or Oracle Planning and Budgeting Cloud Service (PBCS) solution. Our customer’s planning application was used to analyze sales data from an external system. The results of this analysis fed into…   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.