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

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

This blog post has been prepared and written in cooperation with Joel Acha , Oracle ACE Associate & Senior Business Solution Architect at Qubix Intl. Parameters in Oracle Analytics The use of parameters in OBIEE (the predecessor of Oracle Analytics ) is a feature that made it possible to add session personalisation to the user experience. This feature has been missing in Data Visualisation workbooks until now. The March 2023 Oracle Analytics Cloud update has a few product updates but the most prominent new feature of this update is undoubtedly the introduction of parameters to Data Visualisation workbooks. About Variables in Oracle Business Intelligence (OBIEE) We’ll start things off by taking a look at what functionality existed in OBIEE . There are several variable types that could be used to pass static or dynamic values. Session Variables are assigned a value when the user signs in to Oracle Analytics and their values persist for the duration of the user session. Th...

Oracle Analytics has been publicly available for more than three years now. Since the beginning Oracle has been improving the product and many innovations have been into the product stack, expanding into areas like data visualization, data discovery, data management, augmented analytics, machine learning and others quite heavily.  The gap between Oracle Analytics and its predecessor Oracle Business Intelligence has been widened and many Oracle Business Intelligence users have decided to upgrade to Oracle Analytics. On the other handside, we can still see a lot of Oracle Business Intelligence users continuing to use Oracle Business Intelligence.  I think that today, Oracle Analytics has matured enough and is providing so many new features that the time has come for all existing users of Oracle Business Intelligence to seriously consider a move to Oracle Analytics, either that being migrated and implemented within Oracle Cloud Infrastructure as Oracle Analytics Cloud, or on-prem...