Skip to main content

Posts

Featured post

Semantic Model Series: Creating a new System Connection

Working with data in databases requires Oracle Analytics administrators to create connections. There are two types of connections: "Regular" connections connect Oracle Analytics to databases and allow users to retrieve data. "System" connections are used to create and maintain semantic models and metadata repositories. In Oracle Analytics, both connection types are required . Regular Connections I'm using the term "regular" here, as Oracle does not use a specific label for this type of connection. It simply refers to a connection that allows users to retrieve data and analyze it using Data Visualization . Oracle Bootcamp uses the following tables: To create such a connection, navigate to Data in the Navigator menu in Oracle Analytics. Under the second tab, all connections are listed. In our case, the list is empty: To create a new connection, click Create in the top-right corner and select Connection : The Create Connection dialog ...
Recent posts

Exploring Oracle Analytics AI Assistant: Integrating a 3rd-Party LLM

It’s Finally Here! AI Assistant has been available in Oracle Analytics for a few months now, but until recently, I hadn’t been able to test or use it. Why? Because Oracle only enabled its built-in LLM in select regions and on instances with at least 10 OCPUs. Is that a reasonable limitation? Probably. But for those of us who aren’t spending thousands of Universal Credits on our OAC instances every month, it’s also pretty frustrating. A powerful temptating feature—so close, yet still out of reach. With the March 2025 release, this is finally changing! Oracle has enhanced the Oracle Analytics AI Assistant by adding the option to use third-party LLMs. And of course, I immediately put it to the test. What is Oracle Analytics AI Assistant Oracle Analytics AI Assistant is a built-in AI-powered feature in Oracle Analytics Cloud (OAC) that helps users interact with their data more intuitively using natural language . It leverages Large Language Models (LLMs) to assist with data explora...

Retrieving Substitution Variables from Oracle EPM Planning into OAC using REST API

Since a few releases ago, Oracle has introduced native connectors that connect Oracle Analytics to Oracle EPM Application. That way, planning data from Oracle EPM Cloud can be retrieved into Oracle Analytics for reporting and analysis. However, this was just a first step in to EPM/Essbase world. There are several others required as well, for example: Support for EPM Cloud/Essbase data sources in Semantic Modeler: this hasn't been provided yet, however we can expect it in January 2025 release of Oracle Analytics Cloud. Substitution Variables can not be imported directly with the data. But there is an option to use REST API to get all of these variables. Selection Steps is a functionality known from "classic" Oracle Analytics (Dashboards and Answers) where users can select specific member of the hierarchy and display only its descendants based on hierarchy or similar relationship (ie. leaves of hierarchy). This post is about retrieving Substitution Variables using R...