Oracle Data Integrator (ODI) Load Parameters for Oracle Business Intelligence Applications (OBIA)

May 22, 2015

Oracle Business Intelligence Applications (OBIA) use substitution variables which control the way data is loaded.  These variables must always be configured during an implementation of BI Applications.  The most important of these are the extract dates – which control the timeframe of data to be loaded into the system. During the initial phases of a BI Apps project you would…   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.

Four Ways to Better Incorporate Functional Requirements in a Planning Solution Implementation

May 20, 2015

During the requirements and design phases (pre-implementation) in an Oracle Hyperion Planning implementation project, the idea of improving the actual planning process often gets lost, recreating process issues in the new solution.  The steps below demonstrate some important functional items to consider during requirements and design for a planning solution. Consolidate Data Entry and Calculations Most of 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.

Oracle Planning and Budgeting Cloud Service (PBCS): Mapping Smart Lists to Dimensions for Attribute Reporting (BSO to ASO), Part Two

May 7, 2015

In Part One of this blog entry, I explained attributes, Smart Lists and how a planner can pick and choose various options from a drop-down list of Smart List values.  In this blog entry, I explain this entire process in more detail. When a customer has specific attribute reporting requirements, using Smart Lists can help solve this…   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 Planning and Budgeting Cloud Service (PBCS): Mapping Smart Lists to Dimensions for Attribute Reporting (BSO to ASO), Part One

May 7, 2015

This blog entry focuses on configuring Oracle’s Planning and Budgeting Cloud Service (PBCS)  in a unique way to report on various member attributes. At this point, you might be thinking, “Hang on, can’t we report on attributes in Oracle Hyperion Planning already, by simply assigning attributes to a base dimension?”  Traditionally, the answer is yes. Why to Use Smart Lists for Attribute Reporting in PBCS…   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’s Latest White Paper: A New Way to Authenticate Oracle BI (OBIEE) and Oracle Essbase?!

April 29, 2015

Here at Performance Architects we typically find ourselves perusing the Oracle Support blogs on a daily basis as they are a hotbed of new and interesting information. One article recently made the rounds of our company email because the content piqued some serious interest – and so, of course, we’re sharing our thoughts with you as well! Oracle’s…   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 Dimensional Security with Oracle Hyperion Business Rules

April 28, 2015

Previously, business rule security was discussed in coordination with menu options in the blog, “Oracle Hyperion Right-Click Business Rule Security” . As mentioned in that article, there are some potential issues with only using Business Rule Security to control the use of menu options for planners in Oracle Hyperion Planning . Below, I’ll overview a possible alternative to control the execution of these rules,…   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 Hyperion Right-Click Business Rule Security

April 28, 2015

If you are a user of right-click menus in Oracle EPM (Hyperion) , they most likely are primarily used for business rules. They’re excellent for allowing users to leverage the form layout in determining how a business rule should be selectively run. However, there is a bit of a disconnect between the use of menus and how data…   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.

How to Automate Oracle EPM (Hyperion) Administration

April 24, 2015

Lights-out automation is often times a top priority during a large implementation of Oracle EPM (Hyperion) , and it’s easy to see why. The primary reasons for implementing a new solution are to cut redundancy times and allow for more data investigation. One of the most obvious ways to accomplish the former reason is to create automated data…   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.

Join us at COLLABORATE 15!

April 8, 2015

It is almost time for the annual COLLABORATE Conference, the largest meeting of Oracle user groups representing the full family of Oracle business applications and database software. COLLABORATE 15 is co-hosted by Independent Oracle Users Group (IOUG), the Oracle Applications Users Group (OAUG), and Quest International Users Group (Quest), in Las Vegas, Nevada! We 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.