Data Integration

Insert and delete data in Anaplan
Hi Team , I'm trying to insert and delete data into Anaplan using below API. Insert : Delete : Is it the right API to insert and delete ? How can I get the Data's task id ? and how to ensure the insertion and deletion of data in Anaplan Thanks in advance Regards, Vinoth Kumar K.
Level1 Training 4.6.5 Activity: Import Data into G3 Location List
How can I set Mapping ? Is it correct below? -Mapping Column2: Location Name => G3 Location Column3: Country => Parent Column1: Location code => Code -Items uniquely identified by Name or Code
Boolean value from a Time Dimensioned to non-time dimensioned module
Hi Team I want to pull a Boolean value from a time dimensioned module to a non time dimensioned module. Source module looks something like Could you please suggest? Thanks
2.3.9.1 Import data into DAT03 Historic Volumes module
The instructions in Level 2 model builder say to follow these steps. * Run Process 9 Import Data from the Hub. * This will pull the data into the Supply Chain model from the Data Hub model. * Make adjustments in order to avoid errors in the import process I got no errors running it and everything imported without me…
Setting ChunkCount
Hello Community, I have read the documentation of Anaplan to learn how to achieve export actions. Firstly, I have remarked that it is recommended to set the ChunkCount to -1 rather than set the exact count, but i didn't find the reason or the explication for this recommendation. Secondly, if i choose to set ChunkCount to…
Import data lists
Hi, I'm trying to import a data list, I have put all the correct details and the file imports successfully, but then in the anaplan list, nothing appears. There are 400 entries and 0 come through. Thanks Piyaa
Uniques Identifier as code for a Numbered List
Can i Use Numbered list Unique identifier as a Part of code for Numbered List?, How long can a Unique Identifier can go? I have a numbered list Named 'Activity List' under a Customer List as its parent and I am Planning to use Unique identifer as a code for that List as Name(Item(Activity…
Organize Anaplan 365 Cards by Model
The Anaplan 365 Add-in allows a user to save Cards as Templates and then subsequently import then into a Microsoft Product like Excel. However, for a company with many Apps or Cards saved as Templates this can get confusing since there's no organization to Cards within the Anaplan 365 Add-In. Names also get cut off so…
Provide detailed log on cloudworks
As an integration admin, it woulf be very useful to be able to get (through api or the ui) a log detail of the last cloufworks run for a given integration. This is necessary as the current error messages are a bit cryptic to understand like "process failed"
Community perspective: IFO – UPPER and LOWER to the rescue
IFO is a very crucial formula to use when working with raw data, staged in Data Hub, to create lists from within the data's metadata. It truncates the metadata within its line item to "Its First Occurrence" to prevent duplicates being imported into its target list. This keeps the action results clean and optimizes…
Untangling Anaplan time mapping in imports
There are four cornerstones in The Anaplan Way, with data being one of them. We all know that we should spend at least 1/3 of the project time on data alone because this is the cornerstone that we have no control over, and it needs to be thoroughly investigated and understood. One of the important things to consider about…
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hello, Can you anyone help me on this issue? some how in Shipping cost, I get output like 0.2949 and that doesn't match with check work. Please find the attachments; Check Work, Data in Shipping in Cost, and Formula. Thank you.
3.3.5 Activity: Create Inventory Ordering
Hello, My data don't match in Beginning Inventory and Forecast Demand as per the outcome in Check Work. Can somebody help me to fix this issue? Please find the attachment. Thanks.
Anaplan Connect (asynchronous or synchronous)
Wanted to check if I have an Anaplan script that calls 2 Anaplan processes Process 1 (usually runs 5 minutes) Process 2 (usually runs 1 minute) When I run my Anaplan script Will the Anaplan script wait for Process 1 to complete first (so wait 5 minutes) before calling Process 2? (Synchronous) OR Will the Anaplan script…
Importing location flat file in Level 2 Anaplan
Please help me in mapping the location data while importing location flat file in the anaplan level 2 model building.
Multiple lists
Scenario: I created a module with 2 lists. List 1 as Pages List 2 as Rows Line items as Column I want to show only few items in List 2 if specific item is selected in List 1. Ex: List 1: 1,2,3, - List 2, 1a,1b,2a,2b,3a,3b if List 1 selected as 2 List 2 only shows 2a and 2b Tried making List 1 as the parent of List 2, There…
Getting data from a module with no time dimension to a module with time dimension
My source module has no time dimension but with month list, and period in line item. My target module has a time dimension Month Period, (ex. Jan 19, Feb 19, etc) How can I get the data from My source module?
Import Data Module and List at the same time
Hi everyone, I have this concern of my current model, since the user will be the one to add/upload the data. I need a friendly dashboard for them to upload the file to a Data Module. But what will happen if there are new data even amongst the lists inside of that uploaded file? So I made this small test, where I create 2…
OnePlan and Anaplan integration
Have anyone had experience integrating OnePlan (OnePlan Strategic Portfolio Management Software) with Anaplan? I haven't use OnePlan yet, but my client is evaluating it to do their portfolio and project management and there could be use cases in Anaplan that would require some information to flow between the two products.…
2.3.9.1 Import data into DAT03 Historic Volumes module
hi I'm trying to import the DAT03 Historic Volumes module save view Export but I'm getting a lot of ignore items and Failed items
Anaplan Connect Email Script
Hello Team Greetings, I was configuring the anaplan connect script, where right after the import of file is done, i should be able to trigger the email notification. i tried to configure the some part of the script and rest am not able to so looking ahead for the advise. Kind Note : I have installed the SMTP.exe extension…
Is there a way to find the context selector parameter for a page
Question for the tech savy. E.g. The link below is the default URL for the page htps://us1a.app.anaplan.com/a/apps/app/b17cc9fb-23/boards/4d39-ff7302 Now when you send an automated notification from Anaplan for a page, the link includes the default URL above (in orange) followed by values which I'm assuming is for the…
Can we fail a Form Action
Hi, We have a Form Action on NUX that creates a list item and then adds values to certain line items. It was setup as per the requirement but now we want the action to not proceed if the difference between Start Date and End Date (both mandatory line items in the form) is beyond 30 days. Is it possible to fail the action…
SYS04 Product Family Details import problems
I have rebuilt each module associated with sys04 multiple times, have changed the Region codes in the Excel file (as suggested by Vera), have added formulas in the rows for Code and Region, but something is wrong with Country. It keeps giving me the message shown. What have I done incorrectly? Thanks MPW
Level 1 Import settings for Modules and Lists?
Is there someplace that shows what you need to have in each section for importing to lists and modules so I can attempt it several times and then find where I am wrong by checking what is right? I feel I am wasting an inordinate amount of my learning time trying to figure out by brute force, checking for people who have…
8.6.4 Activity of level 1 : The output numbers are different than the correct solution.
Hi, Could possibly someone help me to solve this problem? The output numbers (1'st Pic) are different than the correct solution. In 2'nd Pic you can see the correct numbers, which must seen at the end of the activity. My set up is shown below. Thank in advance!
Data Import Increasing Value
i'm having an issue importing data into our data hub module. i did not change any of the field characteristics, it has a minimum significant digits of 4 and is in number format. The problem comes that when importing the CSV file, there are 0's being added to the end of the number that increases the numbers value. You can…
SYS08 Importing data
I have been having difficulty importing Employee details into SYS08. I have tried dozens of configurations and can't seem to find the right correction to make it work. I have included pictures of my last attempt. Thanks for any help you can give me. MPW
Delete from List using Selection must work differently for the nested list
My Idea: For the backward compatibility, add a check box in "Delete from List using Selection" action. When it's TRUE (default is FALSE) - running the action will delete all elements (leaf and parents) which have TRUE in the selection line item. This won't affect already excisting processes, but will allow to have one…
User to select columns for variance analysis
New variance feature is a long awaited one. And finally we have it! But this feature is almost a hardcode and it does not allow an end user to select which of the two columns to be compared. Before placing this idea I have open a topic in UX Designers forum to collect thoughts of the community about it: MR: User to select…

Data Integration

Discussion List