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

Oracle EPM & BI Blog

5 OpenWorld Takeaways for EPM & BI

If you didn’t make it to OpenWorld this year, we’ve got you covered with the key takeaways from the EPM and BI sessions.

In this blog post, we’ll first look at the EPM highlights, including…

  • An updated roadmap for on-prem EPM Hyperion solutions
  • Moving from Hyperion to the Oracle EPM Cloud

Then we’ll talk about BI highlights, including…

  • Getting started with OAC
  • OAC Essbase Capabilities and Roadmap
  • Active Directory & Single Sign-On with OAC
Read More

Essbase: The Cloud vs. On-Prem

Finance and budgeting teams have long been fans of Essbase — being able to store aggregated values gives users the flexibility to efficiently report and run scenarios. So, when we talk about Essbase, Hyperion Planning is often part of the conversation, too.

But, is Essbase in the cloud going to change the way we talk about and consider Essbase? In this blog post, we’ll look at some of the major differences between on-prem and cloud-based Essbase, and how having this tool in the cloud can help your organization in ways you may not have considered yet.

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

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

Subscribe to Email Updates

Browse by Topic