-
Hyperconnect read and write to SQL database
Hi, I've been researching this and could not get a definitive answer from either here or the Infomatica forums. Can Hyper connect read from on-prem SQL tables, import into Anaplan, and write back to on-prem tables in a SQL database?
-
Anaplan Integration & Anaplan Connect
Hello Community, I'm reaching again support for some questions I have, some of which may appear silly for some experienced users. I've been trying to find an easy way to obtain Action's ID in Anaplan as those are used for our B2BI integrations with other ERP and EPM systems. Initially, I thought I can easily get them from…
-
Using Model Role to filter
I would like to filter a module which uses a list of users (either actual User list or a regular list which is a copy) by the Model Role each user has been assigned. Cannot seem to figure out how to import the model role into a module. Ideas?
-
Import Issue
Hi Guys, I have an issue that I put in a document since for some reason I cannot paste a picture here on the body of this screen. I am sorry if I cannot provide the actual screenshot since it is the clients data. But I recreated it as much as I can. Please see the attachment for details. And again I appreciate the help…
-
Import error formula
Hi Members, I am adding formulas to the properties, I am thrown this error. The actual output (mentioned as output in pic) is shown. Please assist me with the correction, that needs to be done. Regards, Sravan.
-
Import in a numbered list
I am facing this error while importing the values in the numbered list. Can someone please highlight what this error means.
-
Import Action Error
Hi Anaplanners, Need help with the following error: Can you please let me know how to resolve this..? (See the pictures) Thanks in advance, Ankur Sonthalia.
-
Data Integration From Sharepoint
Hi, We have a scenario where we want to load data files into Anaplan Model. Needs some suggestions. Option 1. - Input data files are available on sharepoint. Do we have a way of data integration from Sharepoint to Anaplan? Option 2. - Place the file on P:/Drive (Network Drive) and run a batch job via schedule to pick the…
-
Numbered list import error
Hello Friends, I was trying to import values into numbered list, I was thrown with this error. Please let me know, where I was wrong. Regards, Sravan.
-
Need assistance in Formula
Dear Friends, I have some products and each territory allocation. I want my final module to look like M-1 I have attached .csv file (P1) for reference Regards, S K
-
Anaplan Connect 1.4.3 Export Process Error
Hello, I would like to seek some feedback on this issue that I'm having with Anaplan Connect 1.4.3 Export Process. My hunch is that, maybe it's related to Java -- I have this Java version on my Control Panel: =============================================== Currently, I have the below basic export script: @echo off set…
-
Fixed Export Destination
Hi Team, Is there a way that I can set a fixed Directory destination for an Export Action? I want to always extract to the same directory so the data can be referenced by an Excel Macro Thanks Mark
-
Anaplan 4.3 - Export process
Hi Guys, I am using Anaplan 4.3 and I am planning to do an export process I was able to run the import process successfully but I cannot seem to run the export process successfully. I tried to copy the contents on the Anaplan Connect Document but it is different from the sample script in 4.3 folder. Anaplan Document from…
-
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
-
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…