Enable custom calculation functions in OAC/DV

Rick195

Description: Allow admins or users to create reusable functions for custom calculations inside OAC/DV.

Use Case: Report developers want to run some logic against datasets/subject areas for multiple fields, with the same list of inputs and logic applied to get an output. Instead of having to rewrite the same formula many times, they could create a single function that can be re-used across many custom calculated fields.

Example: A specific business wants to calculate throughput of many different types of workflows between a start and end date, and only count weekdays. Creating this custom logic manually over dozens of date fields means manual code creation for every field, time costs, and maintenance issues if required to make adjustments to the logic or to particular fields.

Business Value: Having the ability for admins or elevated users to create reusable functions will significantly improve quality of life for advanced report builders, improve efficiencies, and promote shared capabilities within an organization. This will also allow organizations to create their own custom/sharable functions for report builders, without having to rely on Oracle for development, nor org admins to add code into backend Subject Areas or data prep steps.

Bret Grinslade - Oracle Analytics-Oracle

You can do this today in Subject Areas. For datasets it is useful.