Data Integration

Unable to locate Account Flat List (.csv file) in LEVEL 2 MODEL BUILDING: SPRINT 1 Data Hub Model
While creating DAT03 Historic Volumes module for Sprint 1 - User Story 3, Level 2 Model Building Course, in the Dimensions: Account Flat list is included, but I'm unable to find the Accounts (.csv) file in the training module. Please Help.
Option for Reversing Journal Entry
Hi All, I'm a new member.. I just wanna know about options in reversing journal entry in Anaplan , there are 3 options : 1. Single-sided 2. Reverse next Month 3. Reverse next fiscal year could someone help me to describe the purpose of each options above Thank You and regards
Anaplan Connect - Multiple line Batch file
Hi team, I have a batch file where I want to split it into multiple rows due to being quite long. I looked online & read that if you use ^ at the end of the row it will continue into the next, this is not currently working & wondering if anyone has any ideas?
Import result shows values are adding up from multiple codes
Hi All, This issue is related from yesterday but with a different approach. We created a Gencon Module (transaction Data of client) and the Inventory Module (data from Gencon without the duplicates). Gencon List has duplicate RU text (Transaction Code) which will be imported to Inventory List eliminating the duplicates and…
More than one Numbered list import
Hi All, Please help to make me understand if I import the one numbered list in other numbered list using "CODE" in this case I can not see the parent of my current numbered list, so what should I do to see the data with parent hierarchy in more than one numbered list items. Regards, Vikas Jain
Anaplan Excel AddIn 3.3
Hi All, We have MS Office 365 ProPlus, version below Excel tends to crash on various machines with the AddIn 3.3 installed. A MS Office quick repair tends to resolve crashes but it is a pain to repair every couple of days. Has anyone had the same experienced and what can be done to resolve this? Thanks, Alvin
Is a source model mapping update needed after model name change?
Hey Everyone, I tested this, but want to be 100% sure before making the update. Can someone confirm that the Source Model mapping does not need to be updated if a model name is edited. I see that the existing Source Model's name does not change, but the imports appear to still be running correctly even though the name is…
Numbered List Import in Other Numbered List
**** All, Please guide me to upload numbered list as a list in other numbered list. I am trying to import using code like as given below but unable to import and getting error. Regards, Vikas Jain
Anaplan Connect - Export Process Script
Hi team, I have a Anaplan Connect script to export a process of 1 action (just for test purposes) but I cannot get it to work. Currently receiving the attached error. My script is below Thanks @echo off set AnaplanUser="email:PW" set WorkspaceId="8a81b09e6181d3600161b51408040171" set…
Import from a Staging Module to a numbered list
I am struggling with the following: I have a staging module, dimensioned by Users, where individual users can input some data (CostCode, Currency, Cost Type, Forecast Reference), and once completed, I want to run a process to create a new item in a numbered list (that holds the full set of approved transactions) and then…
How to create two or more import actions into the same module
Lets say i have a source file need to be imported into module. Few of the line items need to be cleared before import for all rows and few others need not. How can we create two import actions by keeping the same target module and same source file. One work around is splitting the module, but am i missing some other way?…
Data break down based on hierarchy
Hi, I'm wondering if there's a way of breaking data down from a top-level? The data file that I get is an import that comes in at level 2 in my hierarchy. I need to then take this data and show it applying some rules in a module uses my lowest level of data (l4). Thank You Hina 🙂
Module to Module Import
Hi , I have a module ,by versions ,Dimension is a number list . Line items - 1. line item 1> Data Type > List 2. line item 2 > Datatype > subset of list 3. line item 3 > Data Type > Subset of list 4. Other number formatted line item I want to import Budget data into forecast . Action is successful but "line item 2 and line…
Source and target line items have different formats and lists when trying to use lookup.
Hi, I am in need of some ideas, on how to solve a problem I am facing. I have these 3 modules (picture below). The module OC Expected Renewals contains numbers. OC Expected Renewals already pulls in data from from the module 4f ACV Calculation, but, now I also need it to pull in target values from 5f Official Customer ACV…
Anaplan Integration with Amazon S3 using Informatica Cloud
Hello Team, We are currently trying to Integrate Anaplan with S3, Here Anaplan is the Source and we need to place files into the S3 Bucket. The metadata tables have been created in the relevant S3 bucket. The requirement is to have the CSV files containing the data from Anaplan and a Manifest file to be placed into the S3…
Model to Model data import from Module and ALM
Hi Experts Building a functionality to deploy to production which requires an automated Model - to - Model module data import through custom scheduling. We use ALM. Both modules, i.e, the source module in one model and the destination module in the other model are being built in DEV. Upon deployment to production, what…
Data Import into a Module using a numbered list
Hi, I would like to understand how an import action works for a mapping on a numbered list. I have an import action set up between 2 modules in 2 different models. Both the modules use the same numbered list. Since the mapping for the numbered list is on name or code the system ends up mapping on the name(Unique number Id)…
File to Module Import Doubling Number
Hey Anaplan Community, I am having difficulty achieving the desired result with a file import to a list and then module. I wanted to see what workarounds have been used. Below is a simplified example of what the file structure looks like. File: Style Manufacturing Pieces 12345 2 12345 2 12346 3 12346 3 The information is…
Your help is needed! Excel and PowerPoint add-ins: best practices
Hi all, I am reaching out to the Community to get your input about best practices for the Excel and PowerPoint add-ins. Please share your tips and tricks to make the use of the add-ins as efficient as possible! The suggested themes are: * Governance of the add-in: upgrade process, version control, COE management of the…
Comparing two modules
Hi - Because of a unique use case, we had to create two modules with similar information except a couple of columns. I want to compare if the data is correct in the new model. Can you please suggest on how I can do this ? Sunl
Boolean Formula - Match line item with date to date on column i.e. item(time)
Hi, I am trying to write a boolean formula that will create the check mark where the formula finds a match between another line item containing a date and the calendar date on my columns, i.e. item(time). Attached are my current views and what I am trying to accomplish. Can someone please help me write this formula? I do…
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
Error while adding client certificate to anaplan
Hi, I am trying to add client certificate to Anaplan using Anaplan Administration->Security->Certificates. Received following error (screen shot attached) "No active user found with email address <abc@company.com> and tenant id <1214....>" Note: I downloaded SMIME certificate (issued by GlobalSign PersonalSign Partners CA…
Anaplan Connect Authentication Error
Hello, I'm trying to run a batch file for Export, but I am getting an authentication error. Please let me know how to fix this. Thank you, Veena My code: @echo off rem This example runs a Process that contains an Export actions set AnaplanUser=xx:password set WorkspaceId="xx" set ModelId="xx" set…
Level II Sprint III Model
Please suggest a Link from where I can download the FP&A Model.
History information seeking
Hi Friends, Any lights on how is ID values generated? It is sequential but why it starts with 200? I hope it's not year.
Create Technical Names for an Application
When you create an application it is often the case that you create a User Friendly name which is fine however when you then create any imports using this as a source the description will include this name and I always find myself having to edit the name by abbreviating the name of the application so for instance Data Hub…
Anaplan Excel Add-In 3.3 (Read/Write Query)
Hi all, I understand the ability to create a read/write connection with Anaplan was reintroduced in v3.3 of the Excel add-in. Where does this feature reside? I am using v3.3.44.0 and below is a screenshot of my toolbar; I have full access and workspace admin permissions, I also have write access enabled on the version and…
Limitations Of List Members Of General LIst.
How many list members can we insert in a list at a time.
KPI's Mapping from multiple lists
HI, In my datahub I have transaction list that I deconstruct into financial elements, profit centre, cost centre, gl account, order number in a mapping table. I have to report KPI's that are built up from multiple GL accounts and multiple Internal Orders, and I am wondering what approach to take to create a secondary KPI…

Data Integration

Discussion List