-
Reduced number of items to map to
Hi, I am trying to map 30+ columns, similar to how one of my models is set up but in the new model I can only map 3 columns. The source data is the same for both. Does anyone know how to increase this? Thanks, Tom
-
Anaplan Excel add-in Login Issue
Hi All, One of our business user is on 64 BIT Excel. When tried using anaplan excel add-in login, it never shows up the pick up account screen. The screen is always blank and never loads. Did any of you face this issue? If you did, what is the fix for this problem. Regards, DDYal
-
Anaplan connect error
Hi all, I am getting the following message while running Anaplan connect with java. Please help in reaching out. Using Class-Path: C:\anaplan-connect-release-3.0.0 (1)\anaplan-connect-3.0.0-jar-with-dependencies.jar \lib\%l was unexpected at this time.
-
Action with multiple source models
Hi community, I have a page with 2 source models: Model A and Model B. I want to add an action card which runs a process from Model A. When I add the process to the action card, it automatically adds a process from Model B to the card. And the 2 processes don't have the same name. So, if the user selects Model B and runs…
-
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…
-
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
-
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.
-
Failing to import Data In Region Flat -- Model Building activity Level 2 Sprint 1
Region Flat List in Tree View: Region Flat List in Grid View I'm getting this error while importing the data:
-
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…
-
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…
-
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…
-
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…
-
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?
-
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…
-
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 =…
-
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,…
-
【Action】Successful message
Hi, I tried to run Action in APP page. But I couldn't check the successful message. I want to check the number of import data. (I can check failure log.) Is Anaplan maintenance team doing any maintenance?
-
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.
-
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…
-
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…
-
AWS Data Lake (AWS Glue) Connection with Anaplan
Hey, Can someone suggest good DL connector, which pull the data from AWS data lake (AWS Glue) into the Anaplan without manual intervention. Thanks In Advance ! @jesse_wilson @rob_marshall @ben_speight
-
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…
-
Import and Export Function Process
Hello, I am new to the anaplan software and would like to know the step by step process for adding a Export and Import button on a dashboard. Also I will need to add an Export filter so that I can select what department, version and Time I would like to see when the data is exported. Thank you.
-
Percentage format issue
Hello Anaplan Community, I am at the beginning of the training program and have encountered an issue with the percentage formatting while creating several modules in Anaplan. Let me explain : I am importing data from a csv file with bonus percentages by department. In my source file, the value of my bonus % is as a decimal…
-
Transfer the value from one time period to another time period
hey guys Please let me know is there any function for Transfer the value from one time period to another time period Without using offset,post,lag need to transfer the values directly
-
Importing data Into Half Year Columns or cells
Hello, I have a module where I taken time ranges in weeks and Available Aggregation as Half-Year. Now I have a source file with the time range of Half Year (H1 FY20, H2 FY20) (Except half years, I don't have a data in weeks or months in my source file) . In my module my half year values are aggregation of months and weeks.…
-
Converting a list to another list
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accounting software, and data that comes from our enterprise reporting software. Sometimes the naming conventions of things are…
-
export to S3 using cloudworks failing
I am trying to export data from anaplan to S3. I have set up the connection and it went fine. But the export fails with the message as follows: Your integration failed because of invalid connection. Check your integration setup and try again. Not sure what I am doing wrong here.
-
Code Generation on duplicate information entered by users.
Hey Folks, I am trying to generate code in the module in which user list is already applied, due to request from the team I want if the same information is entered by the user1 and use2 it should update the counter accordingly surpassing the users. for ex. if I have user 1 entered information as "abc" so the generated code…