Categories
Enable custom calculation functions in OAC/DV

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.
Comments
-
You can do this today in Subject Areas. For datasets it is useful.
1 -
Hi @Bret Grinslade - Oracle Analytics-Oracle, are you referring to Semantic Modeler? If so, that'll be a helpful update when my organization transitions off the Model Administration Tool.
And if so, does what you're referring to mean that Subject Area builders can use reusable functions within Semantic Modeler only, or that report builders inside DV/Workbooks can use those built/custom functions as well?
This ask is for the latter; an option for the creation of custom calcs that users/report builders inside DV can use in their custom calculations inside a DV Workbook. While the option for Semantic Modeler would certainly be helpful; that's not the audience this idea is intended for.0