Hello, we've established a connection between an Anaplan module and a Google worksheet through an Add-on. What are the available methods for setting up an automated refresh schedule from Anaplan to Google Sheets?
@pchauhan : Maybe this can be achieved by "robots" that simulate the mouse actions to connect and trigger refresh like a normal user. (not familiar with the topic)
As per my understanding, to create native automation with Anaplan it is needed to use REST APIs. I am not aware of Anaplan REST APIs to connect and refresh worksheets (Google or Excel).
My understanding is that worksheets (Google or Excel) are ad-hoc methods to check Anaplan data by a particular user (the user needs to connect and refresh data manually).
For automation, usually, it is used data integration REST APIs that export data from Anaplan to a CSV file (export actions launched from Anaplan) and the target file can be also a Google Big Query Bucket (for Google integrations) or Blob (for Azure integration) or on Amazon S3.
Hope it helps
Alex
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New β New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, noβ¦
Why in my model output is blank, after send explainability data.
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Rankingβ¦
