-
Long Term Planning with 2 Models
Hi everyone, We have our large production model, with 100s of modules that are currently feeding our P&L. This houses all of our actual, forecast, and budget data. The rest of the year we will be budgeting in this model for 2023 and 2024, but we want a "Long Term Model" (LTM) where we plan for 2025-2028. Ideally the LTM…
-
Adding items to the master list
hi! I want to know how to add a master list item from the UI screen. Please help me.
-
API Actions (Imports, Process...) Metadata
Hello, In the api 2.0 it is possible to extract metadata from anaplan. This is available for the lists and modules but I could not find an equivalent for the actions. The alternative would be setting an export action, as I want to automatise the extract for several model, the alternative does not fit.
-
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…
-
Cloudworks integration - import action with input parameter
Hi All, I have an import action which required a target period as an input parameter to execute it. Then, a Cloudworks integration has been setup to execute this action. However, there is no way for me to input or setup the input parameter. The cloudworks integration failed with the missing input parameter. Any idea to get…
-
Anaplan Integration with Alteryx
I'm currently experiencing an issue with a new Alteryx to Anaplan connector. I've setup the import and mapping process similar to how we map for Anaplan Connect. I create the imports manually, map the file as "Admins Only" and then add it to a process. On the Alteryx side I reference the process name as a part of the…
-
Get metadata for import action returns the target line items instead of File headers
Hello everyone, We were looking to query the mappings of a file that was being uploaded in the model through the endpoint of get metadata for import action. the link Anaplan Integration API V2 Guide and Reference · Apiary suggests the below statement: " You can use the API to obtain metadata for an import definition for…
-
Get Import ID from Anaplan
Does anyone have a guide or can provide assistance on how to get the API ID from Anaplan from a model?
-
Not getting Task Id while running API call(Export Action)
Hi all, I am using python for integration. After authentication part, I got Export Id through API call. Now using that Export Id for getting Task Id with API Post Method : headers = {'Authorization': 'AnaplanAuthToken %s' % token, 'Content-Type': 'application/json'} data = json.dumps({'localName': "en_US"}) response =…
-
Format while manually exporting data
When we manually export data from the anaplan model, several formats of the data can be exported. I want to know the difference between the two formats 1.Comma separated values(.csv) and Comma Separated values for Excel(.csv) 2.Excel(.xls) and Excel (.xls) not formatted 3.Excel Open XML(.xlsx) and Excel open XML(.xlsx) not…
-
Deploy mode
Hi All, I have deployed a model from development to Production and try to run a script for batch run from other source in production environment, the script was run successfully but data is showing blank? And when i tried to upload the same file manually in production, i am getting error as "Deployed ode is enable for this…
-
Clear Large Amount of Data
Good Afternoon, I hope someone can help, so far it has taken me over 2 hours to clear out a large amount of data in a module (more than 500000 cells). Is there any quick way of doing it? I still got 7 more to clear data from. For some reason when importing data in Anaplan, it did not clear out all data before the import,…
-
Importing into list from subsidiary view
Hello, I am trying to import data into list by creating an saved view in a module. That module has a line item of subsidiary view. That line item is not getting mapped to list subset. Explanation: I have 3 lists L1, L2, L3 (all are hierarchy lists) One list created for requirement to use it as dependent drop down - LD I…
-
Execute Snap Logic jobs from Anaplan
Hi, We are using Snap Logic as our integration tool from GCP to Anaplan. Want to check if there a way to execute a Snap Logic job from Anaplan? Also, if your integration tool in not Snap Logic, Did you invoke or trigger a job in the integration platform from Anaplan? -- Selva.
-
Anaplan Connect : SSL handshake error
Anaplan API: Basic Authentication failed! (Retryable: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target executing POST https://auth.anaplan.com/token/authenticate (SSL handshake:…
-
Integration to between Workiva and Anaplan
Hi, Can I use Anaplan Cloudworks to have data integration between Workiva and Anaplan? I need to load data from Workiva to Anaplan. Thanks, Tom
-
Excel Add-in - New item in list and list reordering issue
Hello, I am facing an issue with the excel add-in, I am not sure how to solve it or if there are any workarounds. The context is, I am using an excel template with over 10 read-only connection for reporting purpose. In some instances, when refreshing "multiple connections", the refresh fails. After running a lot of…
-
Import Lineitem with subset List
Hi, I want to import Lineitem with subset List. I have this below table. We are making production planning by weekly. Week has subset List, which is Lastest week. I want to import Production Planning only Latest week and its amount > 0. I tried to use filter, but it depends on particular week List. How can I import…
-
Stop allowing copy and paste into dependant dropdowns
Hi, We have a field that is dependant and i have unticked 'Allow access to unfiltered items' However if you copy and paste a valid (non dependant) value into the field it allows it I have made it go red as a warning, but can it be stopped so you cannot paste into dependant dropdowns? thanks
-
Recent Data Export Format Change
Hello, The data exported to excel from a module has recently had formatting changes. As of today, when I export a module from a dashboard it appears to no longer have formating. I think this could possibly be related to the maintenance performed over the weekend (05/14/22). Has anyone else noticed this? Will the formatting…