Hello Community,
Is there a way to source into Anaplan for modeling purposes forecasted/consensus macroeconomic variables such as GDP, benchmark rates (Fed Funds, SOFR), Unemployment, etc?
Thanks!
Daniel
Hi Daniel,
Definitely. For example, sourcing GDP, the International Monetary Fund (IMF) domain has that download, which could be imported into an Anaplan Module.
The method will depend on which data integration option or tools are available to you.
If you have a third party tool like Dell Boomi, HyperConnect/Informatica, MuleSoft, or snapLogic, you can just use that platforms' Web Service Connectors to source the data for the Anaplan import.
You can also use Anaplan Connect, creating a batch file that imports export files that are created by a request through the source system's API and schedule that job on a server.
Another option, if your infrastructure landscape includes an Amazon S3 or Google Cloud Platform, is first scheduling the import of the macroeconomic data into AWS or Google BigQuery using its' Web Service Connectors. Then Anaplan Cloudwork's native integration to those platforms would allow for scheduling the imports into Anaplan.
Or, the files can be downloaded and uploaded manually :)
I hope that is helpful.
Cheers,
James
Thank you James!
just be careful because, while this is free public data domain example, companies that have a low tolerance to data anomalies such as the source server not responding usually subscribe to a service that offers an SLA of upper 90% connectivity reliability. An example that I encountered is using the API of a free government hosted Exchange Rate Site. It was okay for several years until they discontinued it or changed the API. So this solution’s vendor data would likely need an SLA buy off tolerance from the business and IT if criticality is important. If it isn’t that requirement, business may be okay with a day outage of that data refresh. I think that’s the biggest challenge here is sourcing these various metrics reliably and including fail-safes to at minimum be notified that the refresh hasn’t occurred.
Lot's of good information. Thank you James.
Do you know what sources are commonly used by planners for Macroeconomic variable forecasts?
@DanielR I did mention it being challenging :) No, a project that I worked saved that challenge for the very end but my work on the Anaplan build had concluded prior to that point.
I just did a search and this looks interesting: https://fred.stlouisfed.org/ It offers an API to source the data. If you do have an Amazon S3 or Google Cloud Platform, one or both of those may have a service that offers this data. I looked at that a bit on the Google side but nothing reliable jumped out (not to say there isn't).
Got it. Thanks, James. Will ping you/community if I have more questions
I recognize. @geometry dash lite, best wishes. I will ping you or the community with any further questions.
@viriyasolar Then Anaplan Cloudwork's native integration to those platforms would allow for scheduling the imports into Anaplan
Does anyone have an example of how they created in Anaplan the ability to impact various lines of the P&L with macroeconomic variables such as Unemployment Rate, Interest Rate, and GDP? Is there an app model that can be downloaded for how this can be done in Anaplan?
Great insights here. The biggest challenge I’ve seen with macro data is keeping the inputs clean and consistent across sources. I usually run quick checks on CSV/API outputs with tools like TextToolz.com before loading them into Anaplan - helps catch separators, duplicates, or formatting issues early.
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…
