-
importing duplicate data into list
Hi. I want to import duplicate data into list like below. When I imported, data which is second same data was rejected. How can I do this? projectA (parent)----employee1、employee2 (child) projectB----employee1、employee3
-
FIND MULTIPLE DELIMITERS
I am trying to take a 3 part Unique ID with delimiters and separate it at the delimiters. I can achieve this for the first 2, but not the last part. ex: 123-0542-236541 LEFT(NAME(ITEM(LIST)), Delimiter in Item Name - 1) = 123 RIGHT(NAME(ITEM(LIST)), Delimiter in Item Name) = 0542 Delimiter in Item Name = FIND("-", Item…
-
Case Study 299 HR planning costs
So for the HR Planning Costs dashboard there is a module where you can input social security, pay raise % and pay raise date and that module affects the details of each employee module. Is there a way where the social security, pay raise % and pay raise date module does not affect every employee, whereas I can choose which…
-
Import file with several sheets
Hi, I have a module where I have a number of line items and two lists as dimension. One as rows and one as page selector. I want to build a function to export all data from that module, edit it in excel and then import the same file again, and hence get the values updated in Anaplan. Now to the issue: When the file is…
-
Import to list with default value
Hi, I have an excel file that needs to be imported into Anaplan and update a list. However, I want all the new list-items to be part of a subset, which I want to set at the same time as I import the list. I do not however have any column in my import file to use for setting the subset (that is, a column that says TRUE to…
-
conditions in anaplan connect batch file
Hi Team, I am facing following issue regarding Anaplan Connect.How to give the condition in batch script? I am trying to import model to model, parallel with I want to change the version for destination model while performing import action For that I want to apply the condition. I have attach screenshot
-
File Import Error: No Value Loader exists for this type: NONE
Hi Everyone, I am facing a issue which is: My source is: .csv file Target is: Module (Importing into 8 line items) Line Items: Format Lift% Number Volume Status List formatted Activity Type List formatted Activity Cost Number Display Type Text Display Cost Number $/unit Number Select Scenario Boolean The file format &…
-
Automatic Mapping - Not Working
The names are not getting mapped automatically, is there an order issue or is there anything else?
-
Hierarchical structures from a customer provided list
we all understand the traditional way of building a hierarchy normally following a top down approach. We sit with a challenge requiring that the hierarchy needed to build up from the bottom up using a lowest level reference code. As per the attached picture. Each lowest level will have a specific code identifying where it…
-
Importing boolean from Informatica for List subset
I am trying to populate a subset using an import triggered through Informatica. Here is how the import is set up in Anaplan ("SS PortCo in Hierarchy" is the list subset): Screenshot 1 Now from Informatica standpoint, every record captured by the query needs to be added to the subset so I am using a hard coded expression…
-
Cannot Install Anaplan Excel Add-In - Misleading Error Message Displayed
Hello, * We are struggling to download the Microsoft Excel Add In - when trying to do so we get the following message:* The Anaplan Excel Add-in requires Microsoft Excel 2016 or 2013 or 2010 (32-bit of 64-bit) to be installed. * This is misleading - the documentation states that Office 365 is supported…
-
How to convert Date to 445 calendar week
Hi All, The requirement from the client is that they will upload the sales history for an SKU by date into Anaplan. Hence there will be 3 columns SKU, Date, Quantity. The model calendar is set as 445 calendar and the end of fiscal year is last Sunday. The problem is I want to convert this flat upload so that I can…
-
Building a Data Hub
Hi Anaplan Team I have built a data hub to store all my data in that model and later transfer the same to my main model through anaplan connect. I am facing an issue: Lot of time is taken to load just 1 file of 200 MB in txt format, approx 20 min is taken to load such files and I have multiple files of same size & format…
-
Hierarchy change
Hi All, Wanted to ask for a best solution of this question if possible. I have a process hierarchy which consists of 3 levels, and I need to extend it by adding 2 more levels between levels 1 and 2 (so whatever is on Level 3 now should go to level 5, and whatever is on Level 2 will be transferred to Level 4). What is the…
-
Anaplan Connect- export file with different versions
Hi, I'm trying to create an Anaplan connect to export an expense forecast file monthly, but don't know how to write an export script so that every time I run the bat file, it can export the latest version forecast. For example, in Jul, we did a Q3 fcst. I created an export action, the script is: set Operation=-export "the…
-
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…
-
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