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