Integration with ERP based on date uniqueness

Can Anaplan able to import data based on uniqueness of date? ( It's a numbered list)

I'm trying to upload data with date as unique factor but not able to succeed at it.

Please find attached screenshot where i try to upload quantity transaction data into anaplan based on customer, size, date uniqueness.

Accepted answers

All comments

LipChean_Soh

Hi @vsbwofficial

Yes Anaplan can take in unique data.

However please have a read of the Best Practice article in the link below https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

You'll see that while you can use Date as part of the unique code, you should avoid doing so, unless there's a very good reason.

Screen Shot 2019-12-21 at 09.30.29.png

Also, i can't seem to see any screen shots posted by you.

Thanks,

LipChean

vsbwofficial

i'm sorry, the screenshot didn't gets uploaded SOF data.PNG

JaredDolich

@vsbwofficial this is a great question.

@LipChean_Soh is right - check out that link that was shared. You may see up to 90% performance improvment and size reduction depending on how big your transaction file is.

Here's an example for you using your data.

First, create your list but do not include date in your uniqueness.

Next, create your transaction module. Notice that time is dimensionalized as well as the customer and size. This is much more efficient than using text. Turn summary off since you don't need that in a transaction module. Set time scale to day. As @LipChean_Soh has mentioned you do not want to make date a text field. Very efficient this way and you avoid the 500 Byte overhead for every list item you create.

Next, Load your first transaction file. here's our data from 12/21/2019.

Import into the correct line items...

Data is loaded successfully without errors or warnings.

Finally, we load 12/22/2019 transactions. Notice that the data updates and does not create an additional two rows.

That is because our transaction list only allows for two unique rows. Anaplan will update the record instead of insert.

karank_*4578

Hi

Is size column in you data is a definitive list ? i.e a product can only be of certain sizes ?
if it is then create 2 lists customer and size and load data into a module dimentionlaised by customer ×size × time(day) with quantity as line item .

else concatenate customer and size as one list as suggested above.

Quick Links

Can you help?

Unanswered questions

ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…