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…
Then we’ll talk about BI highlights, including…
US-Analytics RPD Merge Script:
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
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
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
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
In this two-minute tutorial, I’ll walk you through how to access the OAC RPD in two methods…
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
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
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
