Importing and Exporting Data

Create Shipping Export Module and Create a Saved View
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right. Here is the blueprint of my INV05 And here is the screenshot of the…
Please add filters to the IMPORT actions columns.
Trying to find a source or target in a list of 500+ imports is quite a time consuming process. Adding a filter or a sort to the columns would be such a big improvement I used to copy and paste the import actions into excel, but now it seems you have changed the format of the table and this is no longer possible, so now…
How to tackle duplication import into numbered list with list formatted properties ?
When importing into the list having properties as list formatted it create new list item with every import even if unique identifier already exists While importing transactional data into a List (Numbered List) which has properties Country formatted as Country, Year formatted as Year and Amount formatted as Number. In…
Importing Values to Booleans via Model to Model
Hello, I hope you are all doing well and good. I would like to ask about a challenge that I'm currently experiencing. Situation is, I need to create an action, just a simple action that will be published to the NUX. This will be an Import action within the same module via a Saved View. Please refer to the encircled line…
1.5.6.2 Import Data into Historic Volumes Module
Hi I am having the much trouble trying to import data to the module: I've matched all Run the upload and says it is successful: But then there is no data loaded? I also not that the Time is incorrect? Have spent about 3 hours trying to mitigate this with no resolution. Please help! 😞
Data Import for REV02 module
I'm getting this error while importing data for REV02 module. PFA screenshots.
Why are there items appearing in the source mapping of an action that are not present in the LIS
Why are there items appearing in the source mapping of an already existing import action that are not present in the Line Item Subset? I have updated the LIS and still in source mapping I can see items which are not present in the LIS.
OEG Best Practice: Data Hubs: Purpose and peak performance
You may have heard about a model called a Data Hub, but perhaps you aren’t confident that you understand the fundamentals, primary functions, or considerations when architecting one. There are three main advantages to incorporating a Data Hub: Single source of truth : Stores all transactional data from the source system.…
Mule4 with Anaplan Execute Export streaming Integration (Unparseable date issue)
Hello Team, We are using Execute export streaming Anaplan operation connector in Mule 4. But we are getting the following exception from the Anaplan connector while performing the export option! org.mule.modules.mulesoftanaplanv3.internal.client.AnaplanV2Client: Exception while parsing currentTime java.text.ParseException:…
CloudWorks: Stop hiding flows if model is archived or stop a schedule if flow was hidden
When a model is archived all related flows becomes hidden. If, for testing purposes, there was a schedule set, it keeps running (and failing) in the background even though administrators are no longer able to see or change the flow. One can always bring archive back and stop/change the flow, but it would be much easier if…
Anaplan: Valid To period - 9999
Hi Expert, Good day! Would like to seek your insights on how to upload the ValidTo period as 12/31/9999 and in Anaplan it will become blank (Date format). Since in Anaplan unable to load this period format unless set the format as text. Is there any workaround to handle this one or a system limitation? Thank you in…
Level 3 sprint 1
Hi Can some help me in Understand this step. 4.6.4, Its asking me to update A2 Account List from Data hub Model My first question is source should be " SYS14 Create Account > Product module or " Product Flat list" Second, If I am using module than I am not getting display name to be used Please some one guide me in this…
Levels to show only giving two options, not all levels of a hierarchical list
Probably an easy question but I am working through the level 1 course and it shows how you can aggregate based on a hierarchical list. When I try this on my own model it looks different and there are only two options. My view S01 Is a child of S02 which is a child of S03… S05. I'd like to display only the S03 Level. The…
Delta Load
Is it possible to do a delta load in the Anaplan model? Lets say one flat file is uploaded at 10.00 AM with 5 million records and the same file is uploaded at 11.00 AM with 6 million records. I just want to upload the new 1 million records into my model. How can we achieve that? Thank you in advance!
7.2.1 Activity: Import Data into Product Details Module Question
Hi there, I am having trouble importing data and I think my mapping may be off. When I get to the Product Details Line Items, there are no selections available. Can anyone advise?
Advice on Optimizing Combined Export List in Anaplan
Dear Anaplanners, I hope this message finds you well. I am currently working on a project that involves two separate exports: one containing Project and Project Code, and the other containing Bench Code. Refer excel snip with samples. The receiving system can accept both Project Code and NPI Code, but in Anaplan, we have…
Importing users in deployed mode
Hello Everyone, Could anyone please advise on how we can import the users in deployed mode? Is it possible to import the selective access fields as well? Thanks in advance..!!
2.3.9.1 Import Data Into DAT03 Historic Volumes module
I have been through many related threads but still couldn't resolve this. I get the error: "DAT03 Historic Volumes.Export" could not be located. I tried to remap but get the same error. I provided screenshots for more context. Thanks for any assistance!
Make Integration admin role available for visitors & partners
It's currently not possible to assign an integration admin role to visitors and respectively also not to Anaplan Partners. This makes it a challenge when helping customers with Cloudworks or when just setting up a scheduled model-to-model import. It requires always someone at the customer capable to set-up the connections.…
MB Level 2 Sprint 1: 1.5.2 Activity: Import Data into Beginning Inventory
Hi, I currently trouble importing data into the DAT01 Beginning Inventory module. Kindly advise.
Export PDF from NUX Page
Hello, I would like to export a dashboard from the NUX as a PDF. But the native export from the NUX page doesn't work for me, because I can't display all my columns on the same page How can I select the same properties than in the classic dashboard export ? If not, how can I save this export definition to publish it in the…
Import Saved View - Filter
Hi all, A bit surprised this topic isn't here as it's one of the most common frustrations, similar to the post here. When importing from a filtered saved view there are a lot of cases of missing values. We all encounter it, and the first time it takes very long to determine the root cause. We change the filters but then…
Snapshot
Hi, I have a scenario where I have to take a snapshot every week(forecast periods) -max 6 weeks forecast period. Source Module -Standard Time Scale, Article List, LineItem(which I want to take a snapshot) Target Module- Standard Time Scale, Weekly snapshot LIST(Contains list member of Lag 1, Lag 2, Lag3..6), Article List,…
Is there a way to view model history on the front end?
Is there a way to view model history on the front end? Example: As a front end user I would like to be able to pull the model history, similar to the one available in the back end.
Inquiry Regarding Zero Chunk Count in Anaplan Integration API V2 Downloads
I am currently working with the Anaplan Integration API V2 to download a list of files and obtain their corresponding file IDs. In previous downloads, the chunk count for the files was correctly indicated. However, I have noticed that the chunk count for the same files now shows as zero, despite no changes being made to…
Edit Export Action
User should be able to edit Export Action just like Import Action in case of addition, deletion of line items to the saved addition/removal of filter to the saved view which is being used in Export Action.
Anaplan Integration with Alteryx
I'm currently experiencing an issue with a new Alteryx to Anaplan connector. I've setup the import and mapping process similar to how we map for Anaplan Connect. I create the imports manually, map the file as "Admins Only" and then add it to a process. On the Alteryx side I reference the process name as a part of the…
[Start Here] Anaplan Connector for Informatica Cloud – Part 1: The Basics
Welcome to the basics of the Anaplan Connector for Informatica Cloud. What you’ll find here is a quick overview of the connector before we get to the fun stuff: best practices, use cases and tips and tricks! You’ll find notes on what the connector for Informatica Cloud is, who it’s for, and use cases to give you a taste of…
Model Changes Tracking
Hello, Recently, I have been involved in a Model Building activities. Project has two teams. Original MBs and my team to take over. My question is : if there is a way to track who created a particular module, line item or applied changes? (Apart from "History" tab)
Impacts of copying or importing a model
Introduction When copying or importing a model to a different workspace within the same tenant, it’s important to understand all the pieces that are impacted by this action. It's commonly thought of as 'moving' a model. However, the reality is that a completely new model is being created with a new model GUID.…

Importing and Exporting Data

Discussion List