DataVizMark
I was architecting an APEX extension for an Oracle EBS customer where there was a need to call some standard APIs. These took a little while to run, and as the customer was using an APEX version prior to 23.1 we decided to submit these processes as concurrent programs. They could therefore execute asynchronously and […]
Added : February 5th 2024 On a recent customer project I was able to use Oracle APEX 23.2.2 which has a significant number of new capabilities. One facility was the new Image Upload, which provides a wide range of options to allow users to easily take/select images and crop, format and upload and then tag […]
Oracle APEX is a low-code development tool which is marvellous for developing responsive cloud applications. Oracle Cloud SaaS Applications (aka Fusion Applications) are a comprehensive suite of SaaS applications which are used by many leading organisations to manage their HCM, Finance, Procurement, etc functions. With the release of Oracle APEX 23.2 we now have the […]
Spatial analytics is a powerful tool that provides insights into geographical aspects of data. This technology can be employed to optimize delivery routes, visualize and interact with the geographical distribution of customers, or even plan sales campaigns based on locality. By applying spatial analytics, businesses can go beyond traditional analytics of knowing who their suppliers […]
Oracle Fusion Analytics Warehouse (FAW) extracts data from Oracle Cloud Applications via integration pipelines and surfaces that data in an Autonomous Data Warehouse. The data is structured into facts and dimensions which are modelled into structures called subject areas which are easy to visualise and explore using Oracle Analytics Cloud (OAC). A lot of pre-built […]
There is a new REST API connection available with the September 2022 release of Oracle Analytics. This is currently in preview so does need to be enabled in system settings. Once we’ve enabled this preview feature, the REST API connector is then made available in the list of connections. Selecting it brings up the following […]
Oracle Analytics (Cloud and Desktop) version 6.2 intoduces the Canvas Annotation facility. This is a really useful feature for aiding presenting and storytelling, so let’s look at this with an example. Below I have a simple analytic which is highlighting some spikes related to Invoices on Hold. If we have taken an action to assign […]
Oracle Analytics (Cloud and Desktop) 6.1 introduced conditional formatting in the Data Visualisation interface. The ability to conditionally highlight data elements is clearly very useful when used appropriately and allows us to provide ‘RAG’ statuses to draw the consumers’ attention. To demonstrate some simple formatting, we’ll use a table of monthly ETL runtimes, split by […]
The new sample map application that has been provided for Oracle APEX 21.1 is full of great ideas. After reviewing the application, one example I was keen to try for myself was the ‘Nearest Neighbour’ capability. I had an existing map demo (see previous articles on this site) showing customers in proximity to a restaurant, […]
The http://apex.oracle.com website was recently upgraded to a pre-release version of APEX 21.1 which has a host of new features available for preview. One which specifically interested me was the new maps region. I already had some geocoded data in a table (using Spatial Studio) which holds information about a fictional restaurant and also their […]