Ž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...

28th annual event  Make IT 2023  took place in Portorož, Slovenia, between 1st and 2nd June 2023. The conference actually consists of two conferences:            As organisers, we are very pleased with the conference which has grown in terms of the content  presented and also regarding the number of attendees which has surpassed 350.   I've been involved with organisation as a member of the organising committee, however personally, my preference lies of course with  Make IT - SIOUG 2023 , where I delivered two presentations: OCI Vision and Oracle Analytics: Just like a Box of Chocolates OCI Vision is a self-service AI Service, which applies computer vision to analyze image-based content. It allows developers easily integrate pre-trained models into their applications with APIs or custom training models to meet their specific use cases. In our example, I will explore how to use OCI Vision service to create a custom-bui...

Maps Conditional Formatting Oracle Analytics Cloud (OAC) is now updated frequently on a bi-monthly basis, continuously adding valuable features that enhance user experience and analytical capabilities. The recent May Update, announced just a week ago, introduces several exciting new features and functionalities . One feature that caught my attention is Maps Conditional Formatting —a powerful option that allows you to highlight key data points directly within map visualizations, just as you can with other chart types. So, how does it work? It’s actually very straightforward, using the same conditional formatting model familiar to users from other visualization types. The map above is our starting point, showing profitability by country. Simple and clear, but without any conditional highlights. To apply conditional formatting, click on the traffic light icon ( Manage Conditional Formatting Rules ). This opens the Conditional Formatting popup window. Here, you can choose whether...

Being able to talk to computers using natural language, especially with the recent advancements in general AI models like ChatGPT, has become very popular in the last few months. Everyone is doing it. It's simple, easy to use, and frankly, it can be very useful. What has been around for a while—think Siri, Alexa, or TV remote controllers—has now been taken to a new level and is already widely used in business. In Oracle Analytics, Natural Language Recognition has been available for several years. I remember the early days when the Oracle Day by Day mobile application was introduced. One of the coolest features in Day by Day was the ability to ask questions using natural language. For example, What is revenue by region and channel for seniors? would provide an answer in the form of charts, tables, and more. This feature is still available today, and you can ask such questions in the Search field located on the Oracle Analytics home page. Oracle Analytics then provides the f...