In my previous article I wrote about creating OCI functions from scratch. Now it’s time to show you how to register your functions in Oracle Analytics and invoke them from data flows to transform your data. Ensuring OCI Functions are Compatible Once your OCI function has been created, you must add the oac-compatible free-form tag to it to ensure that it’s compatible with Oracle Analytics. Open the navigation menu in the OCI Console, select Developer Services, and click on the Applications option (Figure 1). ...

In Oracle Analytics Server (OAS) you can leverage custom Python/R scripts to give your users greater control and flexibility over specific data processing needs. Unfortunately, the custom script feature is not available in Oracle Analytics Cloud (OAC), but you should not worry too much about it as there is an alternative: OCI Functions! In this article I’m going to illustrate how to create an OCI function from scratch. It will be followed soon by another one where I show you how to register the function in Oracle Analytics and invoke it from a data flow to transform your data. ...

Does it still make sense to write about the FILTER function these days, when the top trends for Oracle Analytics are mostly related to Machine Learning and fancy visualizations? By looking at the title of this article you can easily guess that my answer is a very firm “Yes, absolutely”! The FILTER function is a must-know feature for any Oracle Analytics Cloud developer to create advanced calculations in their own reports. Despite already being available when I entered the working world in 2010, it’s plagued by a bug and the one line documentation is not exhaustive at all: as a result, people are struggling with it and get wrong values that cannot be used in their Machine Learning models and fancy visualizations. ...