us-analytics.png
Ask an Expert
blog-Hero.jpg

Oracle EPM & BI Blog

How to Connect Power BI to OBIEE

Posted by Nicholas Padgett   |   Business Intelligence,   |   OBIEE,   |   Oracle Analytics Cloud,   |   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

Three Methods for Restarting OAC

In this blog post, I’ll go through three different methods for restarting Oracle Analytics Cloud (OAC), including the uses cases and tutorials for each.

The steps in my previous two-minute tutorial — Opening Ports for OAC – EM Browser Access and RPD Admin Tool Access — are prerequisites for the tutorials below.

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

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

Self-Service Data Transformation: Intro to Oracle Data Flow & Tableau Prep

In the world of self-service analytics, Tableau and Oracle Data Visualization are two tools that are often put on the same discussion platform. In the last year, the conversations surrounding these two tools have increased dramatically — with most of our clients using self-service analytics. In this blog, I am not going to do a comparison rundown between Tableau and Oracle DV. What I do want to show you is two similar tools which introduce exciting new possibilities: Tableau Prep and Oracle Data Flow.

Read More

Oracle Analytics Roadmap: OBIEE & OAC

After attending Kscope18, one thing is still extremely clear — Oracle continues and will continue to be all about the cloud. For example, the title of the Kscope presentation detailing what’s coming to OBIEE is “Oracle Analytics: How to Get to the Cloud and the Future of On-Premises.”

While that does tell you there’s still a future in on-prem Oracle BI, it's also clear that all the innovation will be put into the cloud. In this blog post, we’ll look at…

Read More

Fixing Oracle BI Performance Issues: A Non-Technical Guide

Posted by Nicholas Padgett   |   Business Intelligence,   |   OBIEE

Nearly all Oracle BI customers we speak with have noticeable performance issues. Business users complain about having to wait too long for their reports, and developers are at a loss as to what their options are. And, no one wants to spend time tuning an environment instead of implementing direct business requirements. Unfortunately, there are no shortcuts or quick-fixes to improving the performance of an Oracle BI environment. Normal approaches involve either outsourcing the efforts to a consultancy or attempting to wade through the difficult process on your own. While both options initially seem fine, they’re not maintainable.

Read More

Subscribe to Email Updates

Browse by Topic

See All