us-analytics.png
Live Chat
blog-Hero.jpg

Oracle EPM & BI Blog

OBIEE Development: Merging the RPD with Git (Free Open-Source Tool)

US-Analytics RPD Merge Script:

View On Github

Read More

Discoverer Migration to OBIEE: 3 Methods You Can Use

Posted by Nicholas Padgett   |   Business Intelligence,   |   Oracle Analytics Cloud,   |   OBIEE,   |   AccelerateBI

Is your organization still using Oracle Discoverer? By now, you’re probably aware of the end of extended support for Discoverer, and that we are well outside the extended support window. You could still be using Discoverer for several reasons, but the fact remains, having your business rely on a tool which is no longer supported is expensive, risky, and dangerous.

The Discoverer migration paths aren’t exactly clear, though. Luckily, there’s an upgrade path to Oracle Business Intelligence (OBIEE) or Oracle Analytics Cloud (OAC) that is simple, fast, and affordable. If this sounds like exactly what you need, then feel free to skip down to the bottom. For those of you not convinced of the importance of migration, read on...

Read More

How to Connect Power BI to OBIEE

Posted by Nicholas Padgett   |   Business Intelligence,   |   Oracle Analytics Cloud,   |   OBIEE,   |   UnifyBI,   |   Power BI

Microsoft’s Power BI is a powerful and popular self-service BI application. It allows reports to be developed at an incredible pace without compromising visualization flexibility or design, in addition to being many times more affordable than traditional Enterprise BI applications.

However, as great as Power BI is, it suffers from some of the same problems that all self-service BI applications do. Chief among them is the accuracy and security of the reporting data. Lucky for us, we still use our Enterprise BI application, which guarantees accuracy and security through a governed data warehouse. Leveraging our Enterprise BI application as a data source, while developing reports with Power BI, we can create a secure, accurate, and reliable workflow.

Read More

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

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

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

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

Starting & Stopping OBIEE Components [Video Tutorial]

Posted by Matthew Walding   |   OBIEE,   |   BI Training

In this quick video tutorial, learn the options you have for starting, stopping, and viewing the status of OBIEE components in 12c.

Read More

Self-Service Data Transformation: Getting In-Depth with Oracle Data Flow

In part one, I talked about the common concepts and goals that Tableau Prep and Oracle Data Flow share. In part two, I looked at a brief overview of both tools and took an in-depth look at Tableau Prep.

In this third post, let's dive deeper into Oracle Data Flow.

Read More

Self-Service Data Transformation: Getting In-Depth with Tableau Prep

In part one of this series, I shared an overview of the common concepts that Tableau Prep and Oracle Data Flow share as well as a brief look at the tools themselves. In part two, I want to take a more in-depth look at Tableau Prep and share my experiences using it.

In my first example, I have three spreadsheets containing data collected from every World Cup Match from 1930 to 2014. One contains detailed information about each match individually.

Read More

Subscribe to Email Updates

Browse by Topic