-
Hierarchy Creation
Hi, I want to create 4 level Employee hierarchy from an Employee flat list. The employee-flat list has all employees, but I only need employees under one particular function. (let is assume 30 employees of one specific function out of total 100 employees). There are no departments or cost centers available. The only…
-
Restrict access for import
Hi, I'm trying to amend the UX page for my organization. in the UX page, each user can import data into 'General expense' line item. After they import, they are able to check and view what they have imported. How can I set the access such that each person is only able to view and check the numbers they have uploaded…
-
Hierarchy in New UX export
Hello, When I do export a grid from anaplan in a .xlsx format I'm loosing the tabulations which distinguish my hierarchy levels. Is there a solution to get the correct display in my export ? Here is what I have in anaplan: And here is what I have in my excel export File: Thanks, Antoine
-
Clear Target before Import
I have a users list wherein the users have read or write access to different companies. I have also created a security dashboard with an import action wherein administrators can give or takeaway access to certain companies for certain users. The problem I am facing is that in spite having the correct import action the new…
-
Import Shipping Expenses into OTH01 Module
Hi, I am getting the below error. Here is my mapping What am I missing? Appreciate the guidance here.
-
Import into DAT03 Historic Volumes
Hi, Im currently on Level 2 Sprint 2. For Importing the DAT03 from the Data base to the Supply Chain, I keep getting a error This is stopping me from running the proccess 9. I have connected the Supply chain to the Data hub. Please help, I am lost and have gone back to see what I have missed but nothing is coming up
-
Level 1 Exam Activity 5 - import txt data error
Hi All, I'm stuck and getting multiple errors when trying to upload the SYS08 txt file for activity 5. I saw another forum to not change the txt file to csv and to map e2 to code, but I'm still receiving errors. Do you know of any reasons why this error is persisting? I've provided screenshots attached. Also, anaplan did…
-
Level 2 Sprint 3 INV01 Beginning Inventory - Import from DataHub
I have issue to import Beginning inventory from DataHub view to Supply Chain DAT01 Beginning Inventory module. Loading process has no issue to complete 371 lines, but when I check module, it only imports first Location - Country list. All location sub in DataHub and supply chain list are matched. So Frustrated, Please…
-
Missing data when importing flat file
Hey! I am facing an issue when it comes to a data import. I want to build lists based on a flat file, and I get the file from another system, so I do not have option to modify the source file. The file structure is like the one below: Product CategoryProductCatregory AProduct A Product B Product CCategory BProduct…
-
Can we use Model name & workspace name instead of model id adn workspace id in Anaplan connect scr
Can we use Model name and workspace name instead of model id adn workspace id in Anaplan connect script.
-
Activity: Import from Data Hub to Supply Chain model
Hello, Below is the prompt from Level 2 Model building. My question is the following: 1. How does one import a saved view Data Hub Model into the P3 SKU list? What am I missing? What am I mapping to the Code, Parent, and P3 SKU? a. The import video & materials don't seem to go over importing modules into lists Please advise
-
Anaplan Integrations Roadmap?
Where can i find any information related to Anaplan integrations roadmap? Thank you. Anya
-
Date Format Conversion
I have source data DATE format as 01-01-19(MM-DD-YY) . I need to map this date format to destination format as JAN19(MMYY). 01-01-19(MM-DD-YY) -> JAN19 (MMYY). Kindly someone help me in this .
-
What is Anaplan Live!???
Hi there! I would like to know... What is Anaplan Live Event? I can see pop-ups every day but I can't find clear information about the event. Thank you in advance!
-
Change 100items at the same time,from "Clear target prior to import" to "Only update imported cells"
Hi there! I would like to know how can I change one settings characteristic in my Actions. In particular, would be to change from "Clear target prior to import" to "Only update imported cells" in 100 items at the same time, rather than doing so 1 by 1. It would be very usefull. Thank you in advance Community!
-
Web Scraping within Anaplan
Hello All, I am checking to see if there is any way for web scrapping and loading to Anaplan. From what I understand about Anaplan, there is no direct web scrapping method built in within Anaplan (unless I am not not aware of). If we had to load data from a website, say for example, the stock price of companies from the…
-
L1 Model Building - Lesson 7 Data Mapping issue
I was able to import everything but the formula CODE(ITEM('E2 Employees#')) does not seen to be working. I see everything correctly EXCEPT data in Code line. Any ideas? I already tried saving the downloaded file with opening.
-
How to get data to come in
Hi, We are currently have a module that is dimensioned by a list of dates. Trying to figure out what is the best formula to use to bring List data in as a date for a LI.
-
7.2.1 product data import
Hey Community, I tried different ways to import data, but still i am not able to match code , can you please help me out. I am attaching screenshot below.
-
Anaplan Connect - Export Script
Hi, I am getting the following error, followed by a list of options in my CMD window when i run my batch file. My batch file is as follows (minus credentials and export names); @echo off Set AnaplanUser="Username:Password" Set WorkspaceId="XXX" Set ModelId="XXX" Set Operation=-export "XXX" -get "XXX" rem *** End of setting…
-
DEM 01 Volume Growth rates
Hi there! I've uploaded the file as per the exercise, changed the date to the MMM-YY format. It says 96 items updated. However, the module is showing the value only for January. Please help me with this! Tulsi
-
Export List of Users Access
Does anyone know how I can export a list of what users has access to each entity within Anaplan?
-
Level 1 Model Building Exam Activity 4 - Roles Import Error
Hi there, I've been stuck on the import into the SYS08 Employee Details Module (Activity 4). When I run the import, I get the error below: I think this is what's preventing me from sourcing the right answer for Question 5, since the mapping on activity 5 works well for me. Here's how I set up the Roles list: and I've added…
-
Input module
Hello everyone, I've created an input module where user can fill automatically some data. I need to create a rule to load the new data entered by the user in a collection module. The collection module should has the same dimension as the input one, but I'm not sure which formula I need to use. I don't want to use a Boolean…
-
no values for FY20
Hello all, i am doing level 2 Sprint 2 activity 2.3.9, where i need to use FY 2019 data in order to populate FY20 (ofset formula). My model calendar is at FY 20 while time range is for 2019. but for some reason when i scroll to the right there is no 2020. i might have missed something in previous steps, and now i am…
-
Unable to find correct formula
Can anyone help me with this, please? I'm unable to get the correct formula for this.
-
INV01 Ordering Inventory Export
My export file seems to have everything okay except for the 3rd number onwards on the first row. And I used this formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
-
Rename List Items
Hello, I have a List with names only and no codes. The names in the source system are now increasing beyond 60 characters. I want to change the naming convention in order to accommodate the size limitation. I know I will need to add a code in order to change the existing names. However, if I rename List items, will all…
-
Exporting Saved View & Tabular Multiple Column
Before I go off to support and see if it's a "problem" just want to make sure that it's not me! Have a saved view that has filters on the page selectors and am then looking to export this view using the tabular multiple column option (there are three dimensions as rows already) but when the export is run I get every…
-
L1 SYS08 Employee Details module - Import and Mapping Issue
Can anybody please write down the steps for the particular SYS08 - import and correct mapping As after several attempts and struggling to get it right . Appreciate your support guys.