As our Anaplan ecosystem grows ~10 production models, we are having to spend lots of time testing, especially when moving data from one model to another.
Are there any Anaplan automation testing applications?
How do you all handle this testing challenge?
Great question.
This is a rather open question so I'm just going to give a few thoughts.
Anyway, just some thoughts.
Hey Jared,
Thanks for the thoughts.
I have met with Chris in the past few years while we were establishing our CEO but never truly focused on testing efforts. Do you recommend having dedicated Anaplan testers?
Today we use Dev team + BA with minor functional testing from Business.
This is such an awesome topic. I haven't seen very many questions about it but I know anyone that has to deal with more than one model in a workspace must address this. Let's keep the conversation going. You could probably write a best practice on this - i checked and didn't see one.
If I could only give you one suggestion it would be to give your solution architect the responsibility for maintaining the integrity of the workspace. Ideally, as part of a CoE so the architect can get help when there's a roadblock. Politics always creep into these conversations.
Of course, where you assign the testing work will depend on your ability to get the resources.
Dedicated testers may not be necessary since the testing comes in bursts.
Just a few more thoughts:
Since writing your initial post, have you adopted a new best practice for testing? I was recently introduced to the idea of Test Driven Development (TDD) while learning Python. I really enjoyed the concept of TDD and wondered how I could leverage the benefits of TDD with Anaplan model development.
UAT and checking against existing external Excel models have served me well for initial model buildout. However, I've found the most trouble when small tweaks are needed in a rush: you make the "small" change and it works the way you think it should (it passes a 'unit test'), but there's no regression testing performed on all the other individual units which would ensure you haven't unintentionally distorted downstream outputs.
I spend a lot of time comparing data to make sure things are still behaving, but having tests that I can run instead would save a lot of time. Anytime I start doing something really repetitive and tedious, I quickly get the suspicion that someone out there has an idea of how to do it more efficiently.
I have some vague ideas of how I might implement some testing modules, but my first step was to come to the Anaplan community to see if someone else had already invented the 'TDD with Anaplan' wheel. 😉
Hi Nicole,
It's not recommended by Anaplan but you can use Selenium to interact with objects in Anaplan and check data quickly. Platform Updates sometimes break selenium scripts though.
Regards,
Anirudh
That's helpful to know, and it makes sense why Platform Updates can sometimes break the scripts. Since the testing I'm interested in has more to do with ongoing data validation, I think there are simple yet effective measures I can employ to speed up the testing process without going the Selenium route yet. As I learn more I can automate more, but the important part is that I've become more aware of the value of testing downstream data as changes are made to a model.
If I weren't on a Mac, I think the Excel add-in would have a lot to offer in terms of time-to-value for spinning up semi-automated data validation (but once the Google Sheet Add-In becomes available, I can explore that as an option). However, I think the API will help me achieve a similar goal (with more leg work).