Žiga Vaupot's Blog

Oracle BI Administration Tool Oracle BI Administration Tool has historically been one of the cornerstone components of Oracle Business Intelligence, widely recognized for its robust metadata management capabilities. It played a crucial role in enterprise BI environments by enabling developers to design and implement comprehensive data models that sit atop data warehouse schemas, facilitating consistent and efficient analytical reporting. Using the BI Administration Tool, OBIEE developers design and develop a metadata model, known as a repository, which results in a binary RPD file. This file is then deployed on the BI Server, a key component of the Oracle Business Intelligence architecture responsible for processing user requests and executing data queries against underlying data sources. The BI Server uses metadata information from the repository to perform two primary tasks: It takes logical SQL queries and transforms them into corresponding native queries (e.g., SQL, MDX), d...

In a recent project, a customer required integrating visualizations from Oracle Analytics into an Oracle APEX application running within Oracle Cloud Infrastructure. This article shares my experience with this integration, highlighting useful resources and addressing some challenges I encountered along the way. Integration is not my primary focus, so I started by reviewing Oracle's documentation. Unfortunately, there is no comprehensive "cookbook" available, which led me to explore various resources online. While many blog posts, articles, and videos exist, most are somewhat dated, though still relevant, as both products have evolved rapidly over the past few years. Despite this, I found some excellent resources that helped me significantly. For instance, Mike Durran's blog is an invaluable source for topics like this. I highly recommend his article A Guide to Embedding Oracle Analytics into Oracle APEX for a thorough understanding. Let's begin with Oracle An...