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?
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
