Data Integration

4.8.2 Activity: Import Data into E2 Employees# List - Struggle to import
Hello, I am struggling to import the employees list during the 4th activitiy. I face the error in the screen below ? Is there something missing ? Something I uploaded in the wrong way ? Thank you for your help. Best regards.
Stuck on model 1 exam activity for question 3
Hi, I am on the exam but noticed my DATA02 SKU Volume only populates for January alone. Every other months do not populate. I have tried tracing back my steps but still no positive result. I have checked if someone else had the same problem within the community but no help still. Screenshot below Plese a
SYS06 7.2.2
Hi! I've been trying to figure out what went wrong when importing products.csv, but I haven't been able to. Every piece of information imported correctly, except for the codes for the first 5 candy bars. May someone assist me with this?
Evolve your Anaplan ecosystem with enterprise governance
Center of Excellence Model Governance Workspace Architecture Data Hubs Data Integration Build & Manage Security In this article, you'll find resources to support evolving your Anaplan ecosystem with enterprise governance. This broad topic was covered in depth during Anaplan Live! 2022 — including focused discussion on…
How to check if authentication works after CA installed on Anaplan
Hi, What is the best way to check if authentication works properly after CA is installed on Anaplan? I followed https://help.anaplan.com/1493b16d-7294-47d6-bd8d-056962e9b8da-Use-CA-certificate-authentication to try to check the CA, but it returns "Failure_bad_credential" I'm not a Postman expert nor integration expert so…
Ability to mask or sanitize all of the Production Data within a model
I would like to be able to easily mask all Production Data within a model. Currently, this involves a lot of manual effort. For example, replacing all names with fake names, and all numbers with fake numbers. Being able to do this is useful for a couple of different purposes: * If I need to have Anaplan Support take a copy…
Stomped Level 1 11.3.2 Activity: Import Data into P&L Actual and Budget
I am stomped at Level 1 11.3.2 . Invalid versions, Invalid date or timescale identifier Can someone please help me? Thanks
Mapping Volume Input -Lesson 8
I have done all the solution here for lesson 8, Activity 8.5.3 - Mapping Volume -input. I am still having error. I attached my screen shot - please help
Data Copy for more than 10k rows of a single line item.
Hi Community, What are the possible ways to load a single date into (Date Formatted) line item which has more than 10000 records. I know the few drills which is 1) Importing manually by creating a csv of that single line item with multiple rows 2) Copy down method (applicable only for 10k rows only) Does anyone have any…
Transactional or Bulk: When to use which API?
* What are we talking about? * What’s the differencebetween bulk and transactional? * When to use Bulk API * When to use TransactionalAPI * What else can Transactional API do? What are we talking about? See our refresher here. Anaplan has a set of APIs that allow for a developer to programmatically interact in certain ways…
Ability to Import via .CSV non-US formatted dates
Looking for an enhancement to allow non-US users that don't use US formatted systems to be able to upload .CSV files that contain dates. Currently any non-US formatted files will cause an incorrect date to be populated without any errors or notifications.
3.3.3.2 Importing data into DAT04 module
Hi, I am trying to import the data from the Data Hub model DAT04 Distribution Center Parameters module into the Supply Chain DAT04 Distribution Center Parameters module. My issue is figuring out the correct time dimensions. I am initially going with YYYYMMDD. Could someone point me in the right direction on what to think…
Export Top Level item using Tabular Multiple Column
Dear Anaplan Community, I would like to export data using Tabular Multiple Column (to use it later as export action in Power BI with Anaplan Connector), including the top level item of my list. In the export definition, I did NOT select "Omit Summary Items", however, in my export I don't see the Total row. What am I doing…
2.3.9.2 Update Historic Volumes for Baseline Forecast_i am not able to get data
Hi, I have used below offset formula. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 I am getting all zeros also my volume line item data got blank. At first I was able to see data. But now both the line items showing data as 0. Could anyone please help me. refer attached…
Level 1 Exam Activity 4
When I am importing the data nothing seems correct. Role is completely missing. Please help I am on activity 4 right now.
3.3.3.1 Create Distribution Center Parameters Module
Hi everyone, thanks in advance for any help! I have attached several pictures including my blueprint view and grid view of each module. I believe I have the import set up correctly, screenshot attached. I am receiving "Invalid data or timescale identifier" errors for 371 entries, but I am getting 1484 Updated entries when…
6.6.4 Activity: Add Time Settings by Year Module
Hi there, I am having trouble with this activity. Instead of showing the years side by side, it shows them on separate pages. The second picture is what the module should look like. I have also included the blueprint view. Any idea what I'm doing wrong?
2.3.9.1 Import data into DAT03 Historic Volumes module_unable to run_getting below error
Hi, I am not able to pull the data into supply chain model. Could anyone tell me adjustments in order to avoid errors in the import process. I am getting below error screen. Thank you,
Integration acknowledgement to Anaplan
Hi, In the scope of an integration from Anaplan to a target system using Mulesoft, I want the best and most efffective way to perform "Ready" and "Success" flags. I explain : Mulesoft flow will use a scheduler to connect to the Anaplan connector at a regular timing. If the Anaplan user performed a new calculation and have…
is there a way to forecast expenses by vendors?
I'm trying to forecast the details by department's with their vendors, like for example Anaplan as a license vendor I want to forecast by that line of expense as part of the Technology department that eventually will roll up to the Software expense P&L as part of the total company. Not sure if I need a list for Vendors and…
Get started on connected data architecture
In this article, you'll learn about the different integration options in Anaplan and discover how to leverage them to maintain and automate your ecosystem. Then, learn about data hub best practices and how to operationalize your connected architecture best. Here you'll find a consolidated view of useful links and key…
Anapaln L1 TEST
I have imported SKU list what will be answer of naming part cant get a clue about it ?
activity 7.1.3 Mapping
I am stuck with the activity in Lesson 7, mapping. All my mapping attempt is wrong and I think I understand it. I don't know what is wrong.
Marked as (Fixed Target Item) in the Mapping tab; please specify a value (ERROR)
I'm trying to complete my Level 1 Model Exam and continue to get the below error: Marked as (Fixed Target Item) in the Mapping tab; please specify a value I searched the Community, and have not found any help/solutions. Additionally, I tried to do the same task in the Level 1 Model File that was given in the initial exam…
8.5.3 Activity: Import Data into Volume Inputs Module
Hi - I am trying to map an import into a model and my results are calculated as zero. I attached my mapping and the results. Can anyone help me what is the issue with the mapping please? Thank you so much!
Anaplan Model Builder Level 1 7.2.2 Help
Hello, I imported data into the SYS06 Product Detail module and it went through smoothly while also aligning with the picture show in the "Check Work" section of the Lesson Plan. I tried to enter the formulas for the same module and I keep receiving an error. The error suggest that I have no hierarchy attached to the lists…
Can you take a Copy of a model at a point in time without having to restore it?
Hey team, I want to take a copy of a model at a point in time and see the data in it without restoring the current version model to that point. Is this possible and if so how do I do it? Regards Padraig
Export list updates
Hi Everyone, I have a problem statement in which I have to export the updates in list items. Here is a scenario to picture the problem:- I have 6-10 lists in my model and each list has 6-15 members. Let's say, user updates a list item in one of the list then I want to export this information that which list item was…
2.3.10 Activity
Hi, I am stuck at 2.3.10 Activity: Create Demand Forecast of Level 2 - Sprint 2. I think I am doing somethings wrongly in SYS01 Time Settings by Week module. I applied for FY21. I don't understand first line item has not displayed in Boolean. Why didn't my formula work? DAT03 has not any value because of SYS01. I need your…
Upload same Idlaoder with differents amounts
Hi everyone, Can you help me with the next problem, please? I need to load some information and the criteria for upload is the Idloader list. I am testing what happens when uploading two rows that have the same Idloader but different amounts and I am waiting that Anaplan to upload just the last amount. In this case, if I…

Data Integration

Discussion List