Rittman Mead Blog

How Are My Users Connecting? Analyzing OAC and OBIEE entry points

Are you managing an OAC or OBIEE instance and your life is nice and easy since you feel like having everything in control: your users browse existing dashboards, create content via Analysis, Data Visualization or SmartView and deliver data via Agents or download dashboard content to use in Excel. You

obiee

Working with OBIEE Data in Excel using ODBC

Look at this picture. I'm sure you've recognised the most favourite data analysis tool of all times - Excel. But what you can't see in this picture is the data source for the table and charts. And this source is OBIEE's BI Server. Direct. Without exports or plugins! Querying OBIEE

odbc

How To Poke Around OBIEE on Linux with strace (Working with Unsupported ODBC Sources in OBIEE 12c)

OBIEE 12c (and 11g and 10g before it) supports three primary ways [https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1465] of connecting to data sources: 1. Native Gateway [https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1179] , such as OCI for Oracle. This

Technical

OBIEE BI Server Cache Management Strategies

The OBIEE BI Server cache can be one of the most effective ways of improving response times of OBIEE dashboards. By using data already in the cache it reduces load on the database, the network, and the BI Server. Should you be using it? I always describe it as the

Oracle BI Suite EE

Automated Regression Testing for OBIEE

In the first article of this series [https://www.rittmanmead.com/blog/2014/01/obiee-regression-testing-an-introduction] I explored what regression testing is, why it matters, and by breaking down the OBIEE stack into its constituent parts where it is possible to do it for OBIEE. In this posting, I explore some