-
Log with Period Anaplan Connect
I want to ask to log (Output) Anaplan connect when there is an issue as shown below?
-
User based delete action
Hi I want to give a functionality to the user where they can select a Boolean (say basis state) and delete the data in a transaction list that are mapped to that state ( in a line item in the system module). see table: StateCheck to deleteA BYC D Since the user has selected the boolean for B, only those transactions are to…
-
Import getting ignored for non workspace admin users
Hi All, I have created a simple flush action that wipes out a boolean selection. See the table. User checks a boolean in User Check and then the last action in their process clears out the user check using the flush line item. User CheckFLUSHaY b c d The list dimension has a Selective Access and a DCA so that if one user…
-
1.3.3.2 Import Data into Country Flat List
the instruction says "Remember this is a flat list, there should not be a parent assigned", but while doing so i am getting an error. Moreover, can anyone verify whether the grid view after the import is correct ?
-
Import SQL data in Anaplan
Hello Team, I am totally new to Anaplan, requirement is we have to dump SQL table data to Anaplan. In this case, I need to do Import action set AnaplanUser="myemailId" set WorkspaceId="myworkspaceid" set ModelId="mymodelid" set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Struggling with finding a solution to the error below. Also I attached my import actions and imports from data sources. I hope someone can guide me in the right direction!
-
Delete from list: but first check if any values in versions
Hi, I am looking to create an action that uses the 'Delete using Selection' action functionality. However I only want the user to be able to delete if there is no data against the list item in any version. Is there a specific way of doing this in Anaplan? eg I have a list of GL codes. At some point some of these GLs will…
-
Reduce time scale in imports
Is there any process by which I can reduce the irrelevant months in imports while uploading the file. I cant use time range here. Can I do this with the help of any filter.
-
Load data from One model/module to another via SQL or in any other automatical way
Dear all Having various Models and Modules, is there any automatical way to copy at lowest level of Country (~100 country codes) and Product lines (~300 items) data from one module to another module? Imagine that we are doing P&L Forecast for the future Quarters, and we want our Q4 to be equal to our Budget, is there any…
-
Numbered List in Data Hub to General List in Spoke Model
Dear Members, I am trying to import from from a Numbered List in Data Hub to a General List in Spoke Model. In the Import Mapping settings pop up, it does not map any members automatically and the only option available to do is manually. Has anyone faced this issue? Is there a way to make this mapping automated? Thank you.
-
Help needed with Rest API file upload (using R if possible)
Hello everyone, I am trying to upload a file onto anaplan from R and haven't been successful for quite a bit of time. I will list down the steps I have taken and it would be greatly appreciated if anyone can help 1. Created a file in anaplan and set the option to "Admins Only". The file name is driver_coeff_template.csv 2.…
-
During Export from Anaplan through API we are getting special Charactors 
When we run a process and export a file from Anaplan through API we are getting special characters () in the csv file header like below but when we export directly from Anaplan it comes blank without any special characters which is right and expected Did any one phased this kind of problem, can you please suggest…
-
Import: add "Ignore All Unmapped" option with manual mapping
currently w/ manual importing Match or Ignore are the only options for assign/ignore an item. It would be huge time-saving for Admins to add "ignore all" option so all unmapped can just be skipped. IRL example, source have 400 accounts and target only need use 20 of them. it's very time consuming to click "ignore" for the…
-
Data Import Issue via Anaplan Connect Script.
Dear Expert , While Doing the Import to Anaplan List/Model via Process in Script , I am getting below shown Error. Could you please let me know Since Same script works fine by changing the parameter for other models. Warm Regards Deep!
-
Help! 7.2.1 Activity: Import Data into Product Details Module
I have reviewed several posts to track down why information is not populating. I compared my L1MB SYS modules to the the finished sample modules and they match. Here is how I am importing the Products (1).csv: And here is the result: as compared to the sample file (what it should look like): You can see I have extra rows…
-
Employees list import mapping
Hello all, I have an issue with mapping Employee details data. Would you please take a look? Thanks
-
Anaplan connect via JDBC with SQL DB (partial data loading)
Hi, We are using Anaplan Connect 1.4 to load data into SQL database via JDBC conneciton. the export script when manually exports 2459 but when the export is triggered through Anaplan connect only partial data is getting loaded. Can someone suggest me what is going wrong here? - - 2021-01-26 13:06:16 INFO 216 |--…
-
Exports should allow for added attributes during export window
Exports should allow for added attributes during export window
-
Import without errors and warnings (extra columns in headers and times)
Hi community! I want to bring up the next topic. Best practices and guides suggest that all imports should go with a green check mark, without warning. If there is a warning or an error, then something went wrong and the administrator must intervene. But I found a case where I don't know how to achieve this without…
-
Limitation on data import (anaplan connect)
Hi anaplanner, I have problem with import file using anaplan connect, when i import file with large rows 1 milion or more i have notice out of bonds, but if i import rows less than 1 milion is succesfull. my question is is there a limit to the number of rows that can be imported? Regards, Panji
-
Level 2 Conclusion - Import Final Demand Forecast into DAT02 Module
I'm literally at a loss at what its asking me to do here...nothing I do seems to work so I obviously dont understand the question. Please can you help?
-
Level 2 - Sprint 1 - 1.5.6.2 Import Data into Historic Volumes Module
Hi everyone, I'm having trouble importing this into DAT03 Historic Volumes. I've been at this for 3 hours and I'm not sure what's wrong. Can anyone help? I can't move on to the next activity until I get this right. Thank you.
-
Search Function within Edit Process
It will be great if there is a search functionality for a specific action within the Edit Process (or Create Action -> Process), especially useful for a model with long list of actions. At the moment, I need to search the action from Actions pane, note where its position is i.e. top, middle, or bottom of the list, and use…
-
Import Data from a saved view to another module - Production Data or not?
Hello Anaplanners, I have a saved view from one module that essentially captures the line item quantity at a moment in time and is saved into another module which is then referenced as the "frozen data". I know I need to change the settings for the import or the import data source as production data but am not sure which…
-
Anaplan-Informatica Cloud Integration
Hello, I'm hoping someone has had this error and was able to resolve this. Would like your help on it. I currently have a Dev and Prod model setup and I'm using a simple import to a date-formatted line item action to refresh the current date. I was able to set it up on my Dev model and it works perfectly. But when I…
-
Data Export Script error.
Dear Expert , Looking for your kind guidance , I am trying to export the data via script . we have been given process to use in script to export the data from Ana-plan . When i am passing the Details in Script i am getting below shown error And Script sample as below which i am trying to run. set…
-
Anaplan Tableau Connection error
Hi, We have a refresh extract set up between Anaplan and Tableau Server however it's not very stable. Here is an example of the error message we are seeing: com.tableausoftware.nativeapi.exceptions.DataSourceException: Name: Ajax Module unhandled error Message: {"jqXHR":{"readyState":4,"responseText":"<html><body><h1>504…
-
Import Numbered List
Hi, I'm trying to import into a numbered flat list using a module saved view and the list is returning only the Number ID and not the names. I checked the numbered list option in the General Lists menu and added a display name property formatted as text and selected it from the dropdown menu in the General Lists menu. I…
-
level 2 1.3.3
Hello I was wondering if everything imported correctly. The excel sheet is what I was taking the data from.
-
Anaplan Connect: Master Script
Prerequisites: * This article is designed for those more advanced with Anaplan Connect. * Utilizing CA Certificates is the best practice for Anaplan Data Integrations. The Master Script is best leveraged with CA Certificate authentication in the individual scripts for security purposes. If you would like to learn more…