Importing and Exporting Data

8.6.4 Activity of level 1 : The output numbers are different than the correct solution.
Hi, Could possibly someone help me to solve this problem? The output numbers (1'st Pic) are different than the correct solution. In 2'nd Pic you can see the correct numbers, which must seen at the end of the activity. My set up is shown below. Thank in advance!
Data Import Increasing Value
i'm having an issue importing data into our data hub module. i did not change any of the field characteristics, it has a minimum significant digits of 4 and is in number format. The problem comes that when importing the CSV file, there are 0's being added to the end of the number that increases the numbers value. You can…
SYS08 Importing data
I have been having difficulty importing Employee details into SYS08. I have tried dozens of configurations and can't seem to find the right correction to make it work. I have included pictures of my last attempt. Thanks for any help you can give me. MPW
Mapping problem in level 1
I'm getting this mapping problem as mentioned above please give the hint to go ahead with my learning. Advance Thanks for help.
Level 2 - Sprint 3 Exam
Hello, My INV01 module works perfectly well and matches the training screen shots. I am juste facing an issue when trying to upload the weekly + Order + Schedule to answer a question. When i try to import i have a problem : Anaplan says that some P3 SKU are not found in the list. When i check the mapping i find those SKU's…
Import Data Module and List at the same time
Hi everyone, I have this concern of my current model, since the user will be the one to add/upload the data. I need a friendly dashboard for them to upload the file to a Data Module. But what will happen if there are new data even amongst the lists inside of that uploaded file? So I made this small test, where I create 2…
Expected 2-digit week number in date/period Getting error while impoting
Getting error while importing data Attaching screenshots for reference. need help
10.2.4 Activity: Import Data into Employee Drivers Module
Not sure why this is happening?
ALM - Updates to Module Import Action - Manual Mapping not promoting
Has anyone seen this behavior? Is do, how did you resolve? Module Import Action that includes manual mappings by code to a numbered Production List. DEV Model - Aircraft Type List - numbered, production list - Import Action to Module - update the manual mapping to Aircraft Type List using Code (Action is NOT marked as…
Data Import with different level hierarchy
Hi All, I have a data hub model from where data is exported to multiple spoke models. Hierarchy in data hub is as follows L1 L2 Whereas in one of spoke model the hierarchy is as below L1 L2 L3 I want to make a data import from Data Hub to Spoke model for loading the data at L2 level. The above screenshot in target module…
10.2.2 Activity: Import Data into Non Employee Expenses Module
tHE TOTAL TAB VALUES WON'T SHOW?
QUARTER FORMAT IMPORTING PROBLEM
I have a csv file with Quarter value in this column header Q1_2022 we can't change the column header format, so while importing I'm facing problem (Expected fiscal quarter number in date/period). Is there any solution of mapping to import the file without changing the csv file column header? Thanks, Jagadish Dash
disaggregation logic
Hi guys I am working on an example we have a hierarchy as per my image: whenever i input the country wise then the country data should disaggregate to state level and also, from the state level to district level and
Edit Saved View to include New Line Items
Hello! I have a saved view that currently include 16 line items/columns in an exported report. In the exported report, I need to include 3 additional line items/columns, that has been added along with calculations, to the reporting module "REP005 Deferred Tax Report" (see attachment). My questions is, how do I edit the…
PowerQuery Get Data Connection to Anaplan
Could we please have the ability to Get Data from Anaplan in Excel Power Query (not Power BI which already exists).
On-demand event based triggers
Is there a recommended way to utilize "callbacks" or "webhooks" with Anaplan? I have a use case where Anaplan needs to update Salesforce in real-time via an event based trigger. Use case summary: End-user inputs data into a dashboard, then clicks a process button to "submit" the data to an export ready saved view. The…
Informatica to run process
Hi all, I want to run an Anaplan process from Informatica. How can I do it? I do not know what to put as source in the mapping and then the fields mapping as I just want to trigger the process, there's nothing like a source or target here. Thanks
Set the delimiter for CSV Exports
The European format for CSV file is a semi colon delimiter and a comma decimal point. The current behaviour is some European users seem to get an export in this format even though it is not supported in anaplan. The windows/browser formatting seems to take over while other users get the more usual comma delimited file.…
Referencing line item of module into list
Hello Friends, I use the import from module functionality to update the list from a module line item. However since its a manual process and the list wont get updated for any changes in the line item of module unless i again start the import process, is there any way wherein i can reference the line item of module in the…
Anaplan-Excel Power Query Connector
Currently, Anaplan supports connecting to Power BI via the Microsoft Power Query function * https://help.anaplan.com/e1cdf0b7-631f-4cd6-b4df-a5e0927e1ef8-Anaplan-Connector-Power-BI-Desktop * https://learn.microsoft.com/en-us/power-query/connectors/anaplan It would be extremely useful if Anaplan supported connecting to the…
Level 1 lesson 8.5.3 Volume Input modules
I am unable to recognize what's wrong is going on, have change the pivot also, but then also error is there. Can anyone help me finding out what am i doing wrong in this?
Check Import Source - CSV File
User Suggested Feature Check import source of a csv file, to check who uploaded the file. Currently the option to check is through model history but if there was a way to check import source originally (user) would be useful feature.
Reset a line item
Hello all, I do not find the corresponding course, but during training for MB certification, it was said that the best practice to reset values of a line item (numeric or boolean for example) was to create a line item with no data as format, and to import this line item into the first one. I would like to reset a user…
Run Process 9 Import Data from the Hub ---
Hi Everyone , While running the process 9 import data from the hub , Am getting error , Snip attached
Process or Action runtime column within Anaplan
Team, It would be nice to have Process/Action "end time" captured within the Anaplan system. Currently, determining "run-time" is a manual process unless we use integration such as Anaplan connect or other APIs. There are several benefits of having this in the system, the one I would find most useful here is while setting…
OEG Best Practice: Import action management best practices
An import action section can quickly become disorganized, making ongoing management challenging. Learn why this happens and explore steps to take to prevent this from occurring. Import action section: why does it become disorganized? Anaplan saves every import action that you perform, no matter what. For a new build, the…
Data integration - Members are not added into numbered list during import with Cloudworks
Hi all, I need to import data from view and I have to import all records from differents views so I am using numbered list for the import. The process is working well when I launched the process with my user, all members are correctly added but not with Cloudworks 🤔 As you can guess, I want to schedule the update and I…
Connect Anaplan from Databricks
Hi Team, I need to copy my Delta Tables from Databricks to Anaplan. Can someone provide details/script on how can I achieve this task as there are not much open source details available to achieve this.
import file error
Hi Anaplan Community, Below is a screenshot of the error I receive every time when I try to run a process with and excel file upload. what is more concerning is, if the same file has been uploaded by different user then system works fine? Please let me know how to tackle this issue.
Display an action's Start Date and Time (UTC) on a page for the end user to view
Are there plans to allow the Start Date and Time (UTC) of an action to be forward facing to end users? This could potentially be shown as a tooltip where actions are published on to the page.

Importing and Exporting Data

Discussion List