Žiga Vaupot's Blog

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

I recently returned from Reading, UK, where I had the opportunity to attend the UKOUG 2023 conference . This year's event was particularly engaging, commemorating the 40th anniversary of the UK Oracle User Group. My participation at the conference had a dual purpose. Firstly, I attended to present, and while I was there, I had the chance to join several presentations that piqued my interest. I'm genuinely impressed by the innovative solutions showcased and the quality of work demonstrated by the presenters and their teams. My winners My standout presentation was LLMs are the Future of Conversational AI  by Antony Heljula of TPXimpact. Antony shared his experiences in developing chatbots that leverage large language models in conversational AI. Truly groundbreaking! A close second for me was Gianni Ceresa's (DATAlysis) presentation titled ID Please: Did You Already Ask That to Your Data?  Gianni delved into the crucial aspects of data lineage and governance, addressing the...

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

About Watchlists In this post, I will introduce a powerful usability feature in Oracle Analytics called Watchlists. Watchlists provide users with a convenient way to monitor and interact with their most important visualizations directly from the home page, without needing to open full reports or workbooks. This feature helps users stay informed with live data updates at a glance and improves productivity by reducing the time spent searching for frequently used content. Users often rely on a specific set of reports or analyses in their daily work. Oracle Analytics allows users to mark these reports or analyses as favorites, which places them in the Favorite Workbooks section on the Oracle Analytics Home Page for quick access. Watchlists take this concept further by enabling users to add individual visualizations from their workbooks to a dedicated section on the home page, allowing them to review key insights immediately. Watchlists were initially introduced in Oracle Analytic...