Data Integration

Error on Importing a list item
Hi Experts, Could you give me a clarification for this error? There is no detailed explanation for this. What does this error stands for?
Trying to map data to a line item from a list
Hi, I'm creating an upload into a list. I've then created a module that looks back and returns the values from the list. I need to be able to map certain factories to certain line items. So if my factory is 1 then i need the line item to be returns from another module with a certain heading. The reason I can't use a…
More than one value for non-numeric cell
Hello everyone, I am having some trouble with the model i am currently trying to build, i am trying to import, into a module i created, a file containing a table (in an CSV format of course) with two columns : The reference and the description of those references, so i created two line items (reference, and model…
Create a PDF/PPT Template in New UX to allow customers to create dashboards for exports
Let users create specific dashboards for PPT presentations or PDFs. Doesn't need to be a new board/worksheet, just a specific report that generates and export
Import User List into the model in Deployed Status
Being an Anaplan admin, I would to be able to upload User List into the model in Deployed Status following general approach of imports from files (with ability to upload .csv file). Currently, the only way to do it is to check the import in the system as "Production Data", re-upload source file directly in production model…
Anaplan List Import Error - "Property-based hierarchy import has disallowed duplicate properties..."
Hi there, I have spent a significant amount of time now attempting to get a simple import to work between 2 existing lists for the 299 case study. I keep receiving the error "Property-based hierarchy import has disallowed duplicate properties for given key in target data - cannot proceed". I have attached below an image of…
Limitation Lineitem subset source module
Hi Anaplanner, does lineitem subset have limitation for source module ? thanks
Exporting data from modules Excluding header items
Thank you for your help. I would like to remove the header when exporting data from the module. Can you tell me if you would like to set the header item not to be output?
Dimensions type
Can we use one of the List properties as a Dimension to create a Module in Anaplan?
Anaplan Connect 1.3 Inquiry
Hi, I was just wondering where can we download the Anaplan Connect 1.3 version? I was able to do that using the pdf file I have but now I can't seem to download it anymore. Appreciate the assistance Regards,
Issue on import from module to module
Hi I have a module with Product List, Region List, Time by month and Line items. I am trying to copy the data from Line Item A to Line item B within the same module and it works fine when I do the mappings by column. But when I choose 'Ask each time import is run', it is tripling the data from Line item A to Line Item B.…
Rest Api response with FileName instead of FileId
Hi Team, I would like to know that instead of using the file id in the api get request can I use the filename as (xxxx.xls) https://api.anaplan.com/1/3/workspaces/8a81b0945cdbe1ec015ce678a3f60051/models/F54A3C7D6CE54A0F82EE730DE0FD12B5/files/ Thanks Kandasamy
multi dimension module to flat module
Hi Anaplanner, I have 2 module, 1 multi dimension and 1 flat module i want to take data from modul multi dimension to flat, but in module flat data isblank multi dimension module flat module how to module flat have data from multi dimension
Period Mapping error while importing data between Module
Hi, Import data Between 2 Modules, I have been getting error for period mapping. Please let me know on what needs to mapped for time period Note: Here Time range is been used. and Time Scale is Month Thanks Asha
Hierarchies with numbered lists
I'm trying to create a list where: (a) There are two levels in the hierarchy, let's say "Level 2" and "Level 1", where Level 2 consolidates up into Level 1; (b) Level 2 and Level 1 are both numbered lists with a display name property (c) The members of the lists will be added to over time, and I want to update the members…
How to throw an error when all fields are not populated in a DB and user clicks a button
Hi, I have this table in this dashboard where a user needs to enter in these mandatory fields in order to save this data into a "history log", which is a separate module. How can i make it so that if all three of these fields are not entered in, when the user clicks the save button, it will throw an error? Right now I have…
Addin crashes Excel
The newest version of Excel add in doesn't work with Office. Every time that the notebook is restarted, the Excel tries to load the add in and it crashes. I had to uninstall the add in because of this issue
Anaplan connect log files
Hi All, Is there any way to structure the logs generated by Anaplan connect in text file, It looks very wage and difficult to understand.
Anaplan COnnect Inquiry
Hi, I just want to know. If your transporting data from 1 model to another using Anaplan Connect API. How would you be able to do that? I am familiar with the Anaplan Connect API importing csv to Anaplan Model base on the script below. I checked the documentation pdf of Anaplan Connect and there is an option there for…
How do I have a forumla calculate data to a specific dimension member?
Hello, How can I have a formula calculate data for a specific member of a dimension and place a 0 for the others? 500error thanks iosman
Script to export General List
Hi I am looking for a way to programmatically export the data from a General List to my local server. Any help here would be appreciated. Thanks Regards Prabakaran
Anaplan Connect 1.4.1 inquiry
Hi, I just wanted to ask is there any available sample script using the new 1.4.1 Anaplan Connect? I was able to run successfully Anaplan Connect 1.3 but I am having problems with 1.4. I just need to see a sample script so I can apply it on our Project. Thanks,
Change the name of Excel Sheet during export
Hi all, I search to replace the name of Excel sheet when I export data (by default "Sheet 1") Someone has already done that ? Thanks in advance for your help!
Anaplan Connect - Export Script
Hi, I am getting the following error, followed by a list of options in my command prompt window when i run my export batch file. My batch file is as follows: @echo off set AnaplanUser=XXX: set WorkspaceId="XXX" set ModelID="XXX" set AuthUrl="https://auth.anaplan.com" set Operation= -export "XXX" -execute -get "XXX" rem ***…
Excel Add-in Error - Refresh failed. The required name range could not be found.
Hi all, I am getting the following error after trying to refresh data after connecting to a module through the excel add-in. "Refresh failed. The required name range could not be found." I am using V3.1 and have never had this issue before. I have done some testing and it seems there is something wrong with the name of the…
Defining the default file for imports
Hi Is it possible to specify a default file for some import actions in Anaplan, so that whenever the user clicks on the action, instead of asking the file to upload "choose files", it automatically looks at a specific place for a specific file and runs the import?
How to bring in previous balance into current module? Or how do I bring in a rolling balance forward
I am creating a balance sheet. I am hoping if anyone can show me the best approach. I have two module. Previous balance module and current Balance sheet module. My previous balance module have no time scale. I want the previous Ending balance in my current module. I attached 2 screen shot to show you what I mean. When I…
Adjust Imports View
Hi team, I'm trying to adjust the view of the Imports tab in the Actions area so that all the text is visible. Currently the columns are a fixed width & I cannot adjust them. Likewise I am unable to extract the data to view it in Excel (where I can adjust columns etc) Anyone know how you can view all the data in this…
What is Branch?
Can someone explain in a simple language of what is a Branch?
Import to time based module with "ask each time" time selection
Hi! i have met the following issue. There are two modules: - Target Module: Time based (Year) - Source Module: no time dimension when doing import , I chose "ask each time " option for time dimension , and during import run i select that single year which is presented in the module. the import is running successfully but…

Data Integration

Discussion List