Data Integration

LV.1 Exam Question 4
I've been stuck on this exam for too long trying to figure out where I went wrong. I thought I had the correct formulas but it is not producing the correct values to this question. For the medical cost of the Finance team, I used 'EMP03 Employee Drivers By Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department,…
Manage the saved view - Display by all modules
Hi all! It would be great if you could refine the "Manage Saved Views" feature and add the ability to view saved views of all modules at once, with the fields: Saved view, module, use in action, note. Saved viewModuleUse in actionNoteName of the saved viewThe module in which the view was createdProcesses in which the View…
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello Everybody, I get this error when i lunch the process, can you help me please ? Best Regards,
Cannot import record into numbered list as it has a new name (#1)
Hi, I'm getting the error message 'Cannot add new entities to numbered list when matching involves name'. Attached is the view of the mapping and the datahub I'm trying to connect to. Does anyone have suggestions on this? I tried reviewing this link but I didn't fully understand it.…
Error In Mapping Data
I'm trying to complete model building activity in Sprint 1 Level 2 and facing an error while importing data from the file. Do let me know what mistake I'm making.
Use multiple characters together as the delimiter when importing
Currently if more than 1 character is used as a delimiter in an import Anaplan treats it as an OR, and looks for either individual character and not both characters together. For instance if you want the delimiter to be "|~" then Anaplan will look for just "|" or "~" rather than them both together. It would be good for…
New Lists Changing Previously Created Lists: Potential Parent Hierarchy Issue
Hi All, We are encountering issues where lists which were previously created have been changed when a new list is created. The "New List" is has the "Previously created" lists as its parent hierarchy. For example List Named "Department D2" is correct. A subsequent list called "Department D3" is created which has Department…
Reduced number of items to map to
Hi, I am trying to map 30+ columns, similar to how one of my models is set up but in the new model I can only map 3 columns. The source data is the same for both. Does anyone know how to increase this? Thanks, Tom
Anaplan Excel add-in Login Issue
Hi All, One of our business user is on 64 BIT Excel. When tried using anaplan excel add-in login, it never shows up the pick up account screen. The screen is always blank and never loads. Did any of you face this issue? If you did, what is the fix for this problem. Regards, DDYal
7.2.1 Activity: Help needed
Hello, Having trouble with Activity 7.2.1, I keep getting this failure and I'm not understanding what's wrong. Please help, thank you. Below are screenshots of the failure and my mapping.
Anaplan connect error
Hi all, I am getting the following message while running Anaplan connect with java. Please help in reaching out. Using Class-Path: C:\anaplan-connect-release-3.0.0 (1)\anaplan-connect-3.0.0-jar-with-dependencies.jar \lib\%l was unexpected at this time.
Action with multiple source models
Hi community, I have a page with 2 source models: Model A and Model B. I want to add an action card which runs a process from Model A. When I add the process to the action card, it automatically adds a process from Model B to the card. And the 2 processes don't have the same name. So, if the user selects Model B and runs…
Power BI Connector updated release
Latest release with security enhancements for Power BI Connector for all customers out there activiely using or looking to investigate! See here for more details
Long Term Planning with 2 Models
Hi everyone, We have our large production model, with 100s of modules that are currently feeding our P&L. This houses all of our actual, forecast, and budget data. The rest of the year we will be budgeting in this model for 2023 and 2024, but we want a "Long Term Model" (LTM) where we plan for 2025-2028. Ideally the LTM…
need help for practice
Hi All I want to populate "text line item" which shows string between 1st and 2nd commas of the items in the module. How can i do it. which function should i use here Thank you & regards Yash
Creating ISBUDGETVERSION() similar to ISACTUALVERSION()
Please consider adding ISBUDGETVERSION() function, similar to ISACTUALVERSION(). This would eliminate having to setup another module with only Versions as the list and creating a boolean flag. All followed by IF VersionsControl.Budget THEN .... ELSE...
Adding items to the master list
hi! I want to know how to add a master list item from the UI screen. Please help me.
API Actions (Imports, Process...) Metadata
Hello, In the api 2.0 it is possible to extract metadata from anaplan. This is available for the lists and modules but I could not find an equivalent for the actions. The alternative would be setting an export action, as I want to automatise the extract for several model, the alternative does not fit.
11.3.4 Actual and Forecast Values are the same
Hi there, My actual and forecast values are showing the same output. My forecast values should be different as seen in the example, but I can't figure out how to show the different output for the forecast values.
2.3.9.1 Import data into DAT03 Historic Volumes Module
Hello, I have been having difficulty completing the 2.3.9.1 activity. I utilized this forum to address my previous issues but I am still having trouble. The Historic Volumes aren't being populated. 9.2 and 9.3 seem to have populated appropriately. Please see the screenshots attached.
Lvl2 1.7.3.1
I am not able to import P3 SKU from the data hub saved view
Sales Planning Model: A2 List
Hi, I'm having trouble when trying to import into the Sales Planning Model: A2 List in the Sales Planning Model. I created the necessary System Module in the Data Hub in order to use to populate the A2 List. I also filtered the module so only the valid Account>Product combos show and saved as a view. I then imported this…
8.5.3 Activity: Import Data into Volume Inputs Module
Hi everyone, I'm getting this error message and I don't know what I'm doing wrong.
Failing to import Data In Region Flat -- Model Building activity Level 2 Sprint 1
Region Flat List in Tree View: Region Flat List in Grid View I'm getting this error while importing the data:
2.3.9.1 Import data into DAT03 "Expected week number in date/period"
Hi Anaplan fam! Since I have read almost every post about importing into DAT03 and checked the instructions many times, it seems I have exhausted all possible options. The only way I can import from Datahub is by using Match names in the Time tab. When I add line item "Offset Volumes for 1st Forecast Year", the value is…
Custom scripting line item calculations
I would love a way to be able to use my custom python scripts and the vast amount of Python libraries on line items in a module, rather than use the Anaplan formulas out of the box. It would save time on export/import data to the Anaplan model. I'm assuming the formulas that are used now are some form of Java or C++? Maybe…
Level 2 - Sprint: Activity import Data into DAT03 Historic Volumes Module
Hi guys, I've been trying to inport the 'Historic volume.csv' to the DAT03 Historic Volume Module for the past 2 hours. I already watched all the videos about importing data to module, etc. But I keep receiving this error, "invalid line item identifier", and I don't know what else I can try. Could someone give me a hint?…
Anaplan Connect 3.0 Training Refresh
The Anaplan Connect training was recently revised to include updates and best practices. Anaplan Connect is a simple connection tool for integrating data to and from Anaplan. This training provides an overview of Anaplan Connect 3.0, this includes: * 3.0 Overview * Setup requirements * Anaplan Connect Guide * Downloading,…
Error in key for this row; refers to invalid list item
Hi everyone, " Error in key for this row; refers to invalid list item : Headcount " I get the above error when I tried to import data into Numbered List, which is uniquely identified by combination of properties. Actually, the list item which is formatted by some "xyz" list has list item ' Headcount' Even after that, I am…

Data Integration

Discussion List