Alert Model Builders of Incorrect Formulas/References Prior to Testing

Description: As a model builder, there are plenty of times where formulas or references to other modules are incorrect either by mistake/typo or due to lack of understanding formula syntax. Based on our model size, we have to allow ample time for Anaplan to return the error summary, even in test models. It would be great to have an alert when typing a formula (based on line item formatting, module structure, etc.) that helps us rewrite or reconsider the final formula before trying to push it through and watching the model 'spin' for a while.

 

Example of Enhancement: When line item formatting is inconsistent with the end formula/reference, the border of the formula bar will remain red. This should pick up on basic errors such as mismatched lists or typos. Once the red border is eliminated, the model builder is assured this formula will be processed correctly.

 

Benefit/Impact: The benefit here would be to reduce time waiting for errors to populate and would help guide all model builders in writing formulas correctly.

10 Comments
Community Manager
 
Status changed to: Needs Community Support
Community Manager
 
Status changed to: Under Investigation
Community Manager
 
Status changed to: On Roadmap
Contributor

I was recently at an offsite team meeting.  This was one of the most asked for enhancements.

Occasional Contributor JP
Occasional Contributor

If you are tackeling this already, here is one extension: The error checking understands the format of the calculation result. Why can it tell in a message window, which format it would expect, and not simply offer the solution directly: offer to switch the line item to current formula's expected format. 

Contributor

Good point.

Certified Master Anaplanner

I agree!  I would love to have a formula compiler before submitting. 

 

While they are working on adding this into Anaplan there are things you can do as a model builder to reduce the time of the model roleback you refer to above 

 

-  Always think through your formula before submitting it.  Ie. Check the format of the line item, type the formula in a text editor and then paste into Anaplan

-  Always use a development model so end users don't experience the roll back of the model while making changes 

-  Follow model building best practices to make your model simplier which should decrease rollback time 

-  Anaplan professional services team can help provide a model review and model open analysis to detect what might be causing the long rollback - Reach out to your business partner to schedule this. 

 

Contributor

I agree with Frankie on all her points and would like to highlight using a development model.  As in any software system, smaller is faster and development environments should be kept smaller for that very reason.  In Anaplan, reducing larger lists to sample sets, as compared to test and production, will result in shorter rollback times.

Regular Contributor

This can only be good news. I use a development model to test formulas which is very small, and has a lovely 10 second return time. But sometimes its the simple things, i forgot to change a format to a list, and had to wait 16 minutes for the return.... after 16 minutes i had forgotten what i was doing.

 

Community Manager
 
Status changed to: Considered for Future Roadmap
Users Online
Currently online: 205 members 431 guests
Please welcome our newest community members: