us-analytics.png
Get a Quote
blog-Hero.jpg

Oracle EPM & BI Blog

Opening Ports for OAC - EM Browser Access and RPD Admin Tool Access [Two Minute Tutorial]

Posted by Becky Wagner   |   Business Intelligence,   |   OBIEE,   |   Oracle Analytics Cloud

In this two-minute tutorial, I’ll show you how to open a port for Oracle Analytics Cloud (OAC) to get EM browser access as well as access to the RPD admin tool.

The steps in this tutorial are necessary for the subject of my upcoming blog post — three different methods for restarting OAC.

Read More

PBCS Data Backup and Recovery Scenarios [Tutorial]

Recently, I created several types of backups and recovering methods using the applications snapshots, PBCS exports, and Essbase Data Export business rules to export and import data.

The application exports data in a formatted file in a way that another application can read it and use the data. This typically requires adjusting for naming conventions. We can do this in SQL and in FDMEE. If it’s straightforward — like for recovering data or for migrating data into a different environment — then the Essbase data export will work. The PBCS data export will also work if we’re looking for a non-technical approach. These methods enable the two systems to share the same data.

In searching for the best method, I’ve found a few different options. In this blog post, I’ll show you the business case for PBCS data backup and recovery, along with how to execute several of these techniques.

Read More

Two Minute Tutorial: How to Access the OAC RPD

Posted by Becky Wagner   |   Business Intelligence,   |   OBIEE,   |   Oracle Analytics Cloud

In this two-minute tutorial, I’ll walk you through how to access the OAC RPD in two methods…

  • Accessing it through the Admin Tool
  • SSH into the server
Read More

PBCS and EPBCS Updates (August 2018): Incremental Export and Import Behavior Change, Updated Vision Sample Application & More

The August updates for Oracle's Planning & Budgeting Cloud Service (PBCS) and Enterprise Planning and Budgeting Cloud Service (EPBCS) have arrived! This blog post outlines several new features, including an incremental export and import behavior change, updated vision sample application, and more.

The monthly update for PBCS and EPBCS will occur on Friday, August 17 during your normal daily maintenance window.

Read More

FCCS Updates (August 2018): Enhancements to Close Manager, Ability to Create Journals for Entities with Different Parents & More

The July updates for Oracle's Financial Consolidation and Close Cloud Service (FCCS) are here! This blog post outlines new features, including enhancements made to Close Manager, create journals for entities with different parents, and more.

The monthly update for FCCS will occur on Friday, August 17 during your normal daily maintenance window.

Read More

ARCS Updates (August 2018): Changes to Filtering on Unmatched Transactions in Transaction Matching, Considerations & More

The August updates for Oracle's Account Reconciliation Cloud Service (ARCS) are here. In this blog post, we’ll outline new features in ARCS, including changes to filtering on unmatched transaction matching, considerations, and more.

We’ll let you know any time there are updates to ARCS or any other Oracle EPM cloud products. Check the US-Analytics Oracle EPM & BI Blog every month.

The monthly update for Oracle ARCS will occur on Friday, August 17 during your normal daily maintenance window.

Read More

EPRCS Updates (August 2018): Drill to Source Data in Management Reporting, Improved Variable Panel Display in Smart View & More

Posted by Michelle Heath   |   Oracle EPM Cloud,   |   Oracle EPRCS

In this blog, we'll cover the August updates for Oracle Enterprise Performance Reporting Cloud Service (EPRCS) including new features and considerations.

The monthly update for EPRCS will occur on Friday, August 17 during your normal daily maintenance window.

Read More

Tutorial: Updating Connection Pools in OAC & OBIEE 12c

Posted by Kevin Jacox   |   Business Intelligence,   |   OBIEE,   |   Oracle Analytics Cloud

I recently ran into an interesting issue with a client — each RPD connected to different databases based on the environment (Dev, Test and Production). Due to the client’s security policy, OBIEE developers were not permitted to have the passwords for the data sources.

To migrate the RPD, a member of the DBA team must be contacted to input the passwords for the connection pools. At times, a DBA with available bandwidth can be difficult to locate (even for a few minutes), and the existing ticketing system does not lend itself to “on the fly” RPD promotions (such as Dev to Test).

If only we had a way to apply connection pools to the RPD while keeping the connection pool information secure…

Read More

Automating Backup & Recovery for Oracle EPM Cloud [Tutorial]

What happens when you have data loss or a devastating change to your Oracle Cloud application? Is there an undo button or safety net to help you easily bounce back?

We want to proactively help you with this topic, whether it's preventing minor and major data loss, being prepared in case of application corruption, or you simply want an undo for your application changes. You also may want to surgically undo for a specific application artifact like a form or setting, or a specific slice of data back several weeks. Can you call Oracle for help, or should you do it yourself?

Read More

Managing Metadata in OBIEE 12c [Video Tutorial]

Posted by Matthew Walding   |   OBIEE,   |   BI Training

In this 5-minute video tutorial, learn how system admins manage metadata in OBIEE 12c, including how to upload RPD files using the command line.

Read More

Subscribe to Email Updates