custom function script

Allow users to create custom function via a scripting language like Java. The idea to me is have the capability to become as flexible as needed with scripting.

The use case i have in mind is being able to create a hashing algorythm to use as a code. This can be a work around to the 60 limit character limit.

Comments

Miran

PiotrWeremczuk

Hey, great idea, I'm totally for! I would rather like to see Python / R / Julia kind of lenguages but anyway, any scriptting form would be awesome. Just imagine what can you do with it! It's not only for custom funcitons but also applying some advanced algorithms. Proper forecasting (math speaking) is no longer an issue and you don't have to go outside Anaplan. Machine Learing stuff is just next door. You can even try running some complex sort of AI programs inside Anaplan and what more do you need while taking complex decisions managing your company?

The only problem I can see is that it may cause some trouble for the Anaplan servers since such algorithms are usually quite heavy on performance.

Anyway, can't wait to see it in Anaplan!

schulze

My favorite example: TRUNC(number). Works a lot better than VALUE(LEFT(TEXT(Number), FIND(".", TEXT(Number)) - 1)). Could well perform better.

DavidSmith

@schulze

MROUND works

MROUND(Number - 0.5, 1)

Much simpler than VALUE(LEFT(TEXT(Number), FIND(".", TEXT(Number)) - 1))

schulze

Ok, how about SYSDATE()?

karank_*4578

I do custom scripting and call it from Anaplan by having a link to a batch script which executes a python script. My use case is to get Now() and some other data points . It works but i do agree if we can have it directly from anaplan with possibility of passing variables will be awesome.

I think support of R (https://www.r-project.org/) from Anaplan would be great.

nicholas.elkan

DATEFROMISO(Date) would also be helpful. Much easier than DATE(VALUE(LEFT(Date, 4)),VALUE(MID(Date, 6, 2)),VALUE(RIGHT(Date, 2)))

david.savarin

An anaplan development kit allowing custom code functions to share would definitely increase the reach of anaplan and bring new clients

Quick Links

New ideas

Virtual Data Warehouse using Anaplan metadata
We are writing from Centrify Solutions, an Enterprise Data Integration +AI company. We have developed a solution that integrates metadata from Anaplan and external sources like NetSuite into a virtual data warehouse. This creates a dynamic large language model that can be deployed internally to any data source or securely…
How CloudWorks Changed My Day-to-Day Work
Hello Everyone, I’ve been using Anaplan CloudWorks, and honestly, it has completely transformed the way I handle daily integrations. What I love most is how simple it is — you don’t need deep technical knowledge to get started. It’s simple, user-friendly, and has become an essential part of my daily workflow. If you are…
Select All Members in a Time Level Instead of One at a Time
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: In a working grid I click 'show/hide' and select 'Time'. My time hierarchy is FY > Half > Quarter > Month > Week. I want to display…