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.

Important Patch Set Exceptions (PSEs) for Hyperion Planning 11.1.2.4.005

March 15, 2017

  Author: Andy Tauro, Performance Architects For folks who are deploying Hyperion Planning (the Oracle EPM on-premise budgeting, forecasting and planning solution) 11.1.2.4.005, or for those of you who are already on that version, the Performance Architects team strongly recommends to apply Patch Set Exception (PSE) 24597360. One very important consideration: PSEs are usually not compatible with…   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 Implement Slowly Changing Dimensions (SCD) Type 2 in Oracle Data Integrator (ODI) 12c

March 2, 2017

Author: Margaret Motsi, Performance Architects Tracking historical changes in data (slowly changing dimensions) is a very common Oracle Data Integrator (ODI) task since many industries require the ability to monitor changes and to be able to report on historical data accurately at a point in time. Implementing slowly changing dimensions (SCD) in ODI 12c is relatively easier than 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.

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.

Oracle Higher Education User Group (HEUG) Alliance 2017: Performance Architects Insider Tips

February 6, 2017

Author: Kirby Lunger, Performance Architects We’re less than a month away from the Oracle Higher Education User Group (HEUG) Alliance 2017 conference, taking place from February 27th – March 2nd at the MGM Grand in Las Vegas! Alliance is the largest meeting of Higher Education, Public Sector, and Federal users of Oracle applications in the world.  Performance Architects team has attended this conference for almost ten years,…   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 Use the “XML Search and Replace” Tool in OBIEE

February 1, 2017

Author: Margaret Motsi, Performance Architects Every now and then, changes are made to Oracle Business Intelligence Enterprise Edition (OBIEE) catalog objects.  For example, the column or table names may change as needed. Usually, this requires a quick fix, except when it is a change that affects multiple reports within the OBIEE Presentation Catalog. I faced this situation when some subject area…   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.

Getting Started with The Oracle Node.js Connector

January 25, 2017

Author: Tony Tauro, Performance Architects In an earlier blog post , we offered a brief introduction to Node.js and a few use cases. Now, let’s get our paws dirty and use Node.js to run SQL against an Oracle database. Setup Development Environment First, the prerequisites. The official github site has a complete list but here’s the gist (for a Windows machine): Install Python 2.7 (it needs to 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.

How to Implement Constant Currency (FX Impact) in Oracle Hyperion Planning

January 18, 2017

Author: Vahram Gabrielyan, Performance Architects As a financial analyst for a multinational company, it was my job to come up with variance explanations for our monthly, quarterly and annual financial reports. At the end of 2015, the strong U.S. dollar started causing major fluctuations in our financials. Foreign exchange (FX) fluctuations became a constant talking…   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.

Countdown to BIWA Summit 2017…The Performance Architects Inside Scoop on Conference Events and Presentations

January 11, 2017

Author: Kirby Lunger, Performance Architects The annual Oracle Business Intelligence, Warehousing and Analytics (BIWA) Summit  is taking place from January 31 – February 2, 2017 at the Oracle Conference Center in Redwood Shores, CA, and the Performance Architects team wants to make sure that you’re up to speed on what we think are some of the “can’t miss” events and sessions at 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.