nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Allow Script in R in Data Flow

Benjamin Arnulf-Oracle

Description

Allow Script in R in Data Flow

Use Case and Business Need

Allow Script in R in Data Flow

Original Idea Number: abbbe73024

Find more posts tagged with

Delivered

Data Modelling and Datasets

Status: Delivered

Comments

Brendan J. Doyle-Oracle

The scripting architecture allows for custom R or Python scripts to be wrapped as XML files describing the inputs and outputs. These scripts can be loaded into / registered with Oracle Analytics and are then callable like any other standard analytic function through a generic EVALUATE_SCRIPT ("Scriptname", "parameter name and parameter value list") function.

Oracle Analytics Desktop - Formatting Custom Python Scripts: https://www.youtube.com/watch?v=9ci3h54SuN0
Oracle Analytics Desktop - Running Custom Python Scripts in Data Flows: https://www.youtube.com/watch?v=KSZWsDBog_k
OAC: how to enable Loading of Custom Scripts on your OAC environment: https://www.youtube.com/watch?v=5rIYSDiC4IY

Advanced Analytics in Oracle Desktop: https://blogs.oracle.com/analyticscloud/advanced-analytics-in-oracle-dv

Begoña Villamor

Sorry Brendan but I wouldn't consider this feature as current capability but desired feature.

The video about OAC applies only to OAC-classic. In the current OAC managed by Oracle there is no way to enable the execution of R or Python scripts.

The other links apply to DV Desktop, not to the web tool.

All our customers ask for this feature.

Regards,

Begoña Villamor

Bhavin Khatri

I completely agree with Begoña. Please bring back applying custom R script features in OAC (Oracle Managed). This is a huge benefit and a game-changer.

Bhavin Khatri

This is not a current capability from OAC standpoint. This feature has been taken-out.

Top Leaders

Tarik Branković 45

User_IG5IB 32

Michal Zima 32

Siva Pratap Nellipudi-Oracle 29

SantoshChandrasekaran 18

Top Ideas

Increasing Report Results limit from 5000 to the full report results data set
OAS Classic Report Results display the first 5000 rows and the OAS user needs to click the next button for the next 5000 rows and so on. The 5000 row limit is the maximum allowed to be setup in the OAS Console. OBIEE Report Results support display of the entire report results data set. Our users would like this feature in…
Provide proactive notification of bug fixes/patches that change API response behavior, before deploy
Background We recently identified an issue through an inconsistency in the number of records returned in an API response. This allowed us to notice, after the fact, that a fix had been applied that changed the behavior of an existing API. Problem We understand that information about resolved bugs is eventually made…
Granular permission for Session and Query Logs (Manage Sessions) independent of BI Service Administr
We need a way for non-admin users to view the backend/physical SQL queries executed by reports (via Session and Query Logs) without granting them full administrator access. OAC's custom Application Role model (Console > Roles and Permissions) allows selecting fine-grained permissions instead of assigning predefined roles.…
OAS Certified Data Source (DB2) Enhancement Request
Customer would like to request that IBM DB2 12.x be added as a supported data source for Oracle Analytics Server. They hope that it will be included as a certified and supported data source in the next(Year 2027 ) OAS release. Background: The customer is currently operating a reporting and analysis platform using Oracle…
MCP restriction/ tool restrictions to OAC user groups
We would like to restrict the MCP to certain OAC application roles instead of all the users. Please help us to achieve this functionality.