Data Integration

Data is not getting updated into Production model through integration
Hi Team, I am having issue regarding the updating the records into the production model via integration and action is marked as production data. In test, data is getting updated correctly with same action but in prod action is running but records are not getting updated. Anyone can advise on this issue please? Thanks…
Ways to bring Import Action Timestamp into a line item in Anaplan
Hi All, Is there a direct way in Anaplan by which we can bring the last run time/date of an action to a line item in Anaplan?
Excel Add-in: drag and drop dimensions, view line item formula, keep only/exclude
Please add the following features into the Anaplan Excel Addin - 1) Ability to pivot by dragging and dropping members within the spreadsheet rather than clicking on pivot and filter. 2) Ability to drill down a hierarchy by double-clicking in the spreadsheet 3) Ability to extract just one data intersection using some…
Import to numbered List
Hi People, I want to import transactional data into the model from excel csv file. I formed a numbered list, where I am importing this csv file, identifying the unique key by using a combination of properties, but there are other columns that are not forming part of the combination. (basically, those are values/number…
Anaplan & Fluence Connection
Does anyone know how the connection between anaplan and fluence works… or can point me in the right direction for documentation?
How to remove the New line / Line break Character
Looking for a solution to remove the line break or new line character from the text formatted line item editable by end users. reading the text from the user editable line item to another line item, in the process want to replace new line character if any from the text. Because of New Line character the data while being…
7.2.3 Activity: Import Data into Employee Details Module
When importing data into the SYS08 Employee Details module, my end results looks like the second photo when the goal is the first. I have imputed the correct mapping, and manually mapped the employee detail line items as well as changed the date format to YYYYMMDD. I'm not sure what the error is, I keep getting the error…
SUM Function Example
I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me know, if I am right or wrong? I have shared Screenshots for reference.
Anaplan Connect: Wake-Up Script
Preface: Utilizing CA Certificates is the best practice for Anaplan Data Integrations. The wake-up script is best leveraged with CA Certificate authentication in the individual scripts for security purposes. If you would like to learn more about CA Certificates, click on this guide. Note: Basic Authentication used for demo…
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…
Ability to access multiple tenants with Power BI Connector
Currently with the Power BI Connector you can only access your default tenant but would like the ability to access multiple tenants during log in.
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…
anaplan api 401 Not Authorized using Postman
Using Postman: I can use Post and get an authorization token, but when I create the Get with Authorization = AnaplanAuthToken <token from Post> Content-type=application/json Basic Authentication and workspace ID and Model Id in URL https://api.anaplan.com/2/0/workspaces/<workspace id>/models/<model id> I get: { "status": {…
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.
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:…
Data extraction from Anaplan Data Hub using SAP Data Services
Hi Can we extract data from Anaplan Data Hub using SAP Data Services, are there any limitations to it? Thanks
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…
Delta Load
how I can implement delta load from datahub to Spoke model. the action pulling the delta load is running into the spoke model , then how to mark the transferred data from spoke model to datahub model ?
Cloudworks - Flexibility to choose date of every month when frequency is hourly
While creating an integration with frequency to run hourly ,there is no option to select "date of every month ". If there is a requirement to run an integration every 2 hrs in a day from day 1 to day 12 of month then we have to create numerous integration to achieve this .If above feature ,replication of work will be…
CloudWorks: Duplicate an Existing Integration / Process
Could Anaplan's Product team for Cloudworks enhance it to allow customers to copy an existing integration or process? … This will make it easier to copy existing connections, and then modify them for the purposes of the new integration (for instance, relink them to different Azure Blob directories, etc) This would save…
Cloud export failed _Cloud works(Azure Blob)
Cloud export failed error while running the clouds works integration with azure blob. Do anyone knows about this error and how to fix it?
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?
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!
Enhancement to existing Bulk API for Import Metadata
There is an existing bulk API endpoint that allows workspace admins to retrieve the full list of Import actions from a given model. This endpoint is in the format: https://api.anaplan.com/2/0/models/{{mdlID}}/imports/ where {{mdlID}} is the model GUID. This returns a JSON response, which contains an object called "imports"…

Data Integration

Discussion List