I have the excel files which has to be uploaded in Anaplan at each quarter levels so we are uploading this file four times in an year, each file contains many columns which are lists in Anaplan. There are about 12 Lists (columns in file) and the each file has nearly 40K records. I have created an Input module with the lowest SKU level list in Applies to. The remaining other lists, I have added as list properties to the SKU level list and referred them in the Input module instead of having all the 12 lists in Applies to, to save model space.
1) Now my 1st question is, how do we design the lists to load it?
2) We have already created and loaded very limited data temporarily and now we would like to load full data into Anaplan, so how do we reduce the size of it?
3) The most important think is there are A & B lists having parents but still we created it as a flat list with List Properties as parent due to few unavoidable requirements. We have another C list created as a composite type. This list is has 4000 list items. In the Calculating module where we have A,B,C lists in Applies to, It is calculating C list items(4K)*A-list items*B-list items
This approach consumes lot of space. Please can you suggest any other Optimal methods.